X axis problem

[jlmccabes]

Trying to create a chart with two items (three lines) on the X axis.
2006 2007 2008
Actual Actual Budget
6.38% 5.52% 5.75%
The first two lines are easy, the last line is a calculation they want to
see. Do I have to use concatenation or hopefully an easier way.

 

[Guest]

Not sure if I'm understanding you correctly, but...

Go to the Source Data dialogue box for the Series you want to change and
adjust the Category (X) Axis Labels field to include all 3 cells (assuming
that 2006,Actual,6.38% are in 3 separate cells). I think they will have to
be adjacent cells that are arranged in a logical order though. If your cells
are all over your spreadsheet then, yes, you could use a separate cell with a
concatenation formula and then reference that cell for the Category (X) Axis
Label field.

Hope that helps.

 

[jlmccabes]

WOW - I never thought of using two columns as my data source for X axis. I
am a very happy camper.
Thank you for making my nightmares relatively easy.
Not sure if I'm understanding you correctly, but...

Go to the Source Data dialogue box for the Series you want to change and
adjust the Category (X) Axis Labels field to include all 3 cells (assuming
that 2006,Actual,6.38% are in 3 separate cells). I think they will have to
be adjacent cells that are arranged in a logical order though. If your
cells
are all over your spreadsheet then, yes, you could use a separate cell with
a
concatenation formula and then reference that cell for the Category (X) Axis
Label field.

Hope that helps.