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