Xl 2007 chart axis labels not showing: Req for help

[keith666]

I have updated the data included in the attached graph but the vertical axis data has not been included, (years and months).

What have i omitted to do in this case, can't seem to find how to include this data....

Any help appreciated.

Thanks

[romperstomper]

Select the chart, select the Layout tab in the Chart Tools group, then select Axis Titles - Primary horizontal axis title, and choose the position you want.

[keith666]

?? That only adds an overall axis title below the data already there? The existing chart had year data "embedded" in the chart and did not seem to happen in the new sections (2011 onwards). See chart for detail?

Apologies if this is a basic error on my part.

Thanks

[romperstomper]

Sorry, misread the title. You need to right-click the chart, choose Select Data, Edit the category labels and extend the range - it only goes to column BN at the moment.

[keith666]

SOLVED!! Thanks for all the help, should have known the answer really.

Thanks again

[romperstomper]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save