In Excel, you can assign a name to a group of non-contiguous cells and use this name as a collective noun to indicate the source of the data graph.
For example, if the whole cell "Sheet2" was named "list" must be indicated as a series of data the following notation:
= Sheet2! List
The same method can be used to set the axis labels from a collection of cells, including non-contiguous, identified with a name.
[In Excel, the naming of the cells is obtained Quick as follows:
select the cells, if they are not contiguous to use the CTRL key;
in the Name box (top left in the formula bar) to write a name and press Enter]
0 comments:
Post a Comment