Chart Formulas

[Guest]

I have a chart - this one happens to be a line chart - with the 'X' axis the
years (2003 thru 2010), and the 'Y' axis amounts. My question is on the
'=SERIES' formulas for the lines. In some cases the formula includes both
the 'X' axis cell locations (years) and the 'Y' axis cell locations
(amounts). In other cases, the formula includes only the 'Y' axis cell
locations. (It appears both are included in any original lines set up,
whereas only the 'Y' appears for lines added later.)

Basic question - do the 'X' axis cell locations need to appear in more than
one of the '=SERIES' formulas?

 

[Jon Peltier]

Bill -

If the chart is a line, column, bar, or area chart (that is, the X axis
is a category axis), all primary axis series share the same X data, and
all secondary series share another set of X data. If a different range
is shown for any but the first series, Excel ignores it. If your chart
has a value axis as its X axis (i.e., it's an XY Scatter chart), then
each series has its own X values, and if you omit any, Excel assumes a
simple array {1, 2, 3,...}.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______