Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart Formulas
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? -- Bill @ UAMS |
#2
|
|||
|
|||
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/ _______ BillCPA wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing a Chart Directly?? | Charts and Charting in Excel | |||
Editing a Chart Directly?? | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |