[Solved] Time-Scale Axis & Appearance of Chart

  • 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

  • Hi Ann,


    How about using a bar chart to give the band effect.


    The three dates are stored on sheet1.
    I have added 3 new data series. These are plotted as bars that are as high as the plot area and completely over lapped.


    They use the same scale as the line plot.


    Cheers
    Andy

  • Hi Andy! I looked at the chart you sent and it's great, I'm just a bit confused as to how you did the "bands."


    You stated, re the attached chart: "...How about using a bar chart to give the band effect. The three dates are stored on sheet1. I have added 3 new data series. These are plotted as bars that are as high as the plot area and completely over lapped. They use the same scale as the line plot. ..."


    If possible, can you give me step by step instructions for how to get those "bands" on the attached chart???


    Thanks in advance,


    Ann

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!