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 |
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 |