Hi,
I've been here before when I needed help on comparing data in an Excel chart. Andy Pope helped me out alot by providing samples, instructions, etc. I'm back now with the same chart but a different problem. See below for an explanation.
I'm using Excel 97 & Windows 98.
1. Pls see the attached chart comparing data from the years 2001-2003 by date.
2. Go to Chart Options and Axes and here you’ll see that the primary X Axis is a “Time-Scale” Axis. When you go to Format the primary X axis Scale, (as a Time-Scale Axis), the X Axis can then be changed to Scale the Dates at the bottom of the chart by different units for example, by every 7 days or every 14 days, etc.
3. Here’s the problem: When I got help on this chart before, each year on the chart had a different background color. You can see what I mean by doing this: Go to Chart Options and Axes and change the primary X Axis to “Category” Axis. Now you can see that the background colors have “filled in” for each year. The problem with leaving the chart this way is that now when I go to Format the primary X axis Scale, it cannot be changed to scale by every 7 days or every 14 days, etc.
4. So, my question: Is there a way to keep the primary X axis as a “Time-Scale” Axis AND be able to see the background colors filled in for each year?
Any replies would be much appreciated!
Ann