2007 Fixed X-Axis

[kaledev]

I am having a problem that I have been pulling out my hair over but I am sure there is a simple solution. I have data that goes from week 1, to week 52. This is labeled as 1,2,3...52 in my data. However since I only have data for weeks 1-3, excel decides to only show 1-3 in my x-axis and completely hides everything else. I have 1-52 selected for my x-axis, and when editing it shows they are all selected, but only 1-3 show up in the 'Horizontal Axis Labels' section.

I seem to remember in past versions being able to set a fixed x-axis, is there a way of doing this is 2007? Or any other solutions? I see in Axis Options that you can only do this for dates and not numbers. Thanks!

[Andy Pope]

Even if the category label ranges is set to use all weeks this will not happen if the Values range is not also set to use all weeks.

If still stuck post example of your workbook/chart