Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: shading date ranges (XP)

    You can use the combination chart that's in the custom chart tab. The column-line chart should do it. I've attached an example. You have to fool around with the order to get it right.

    You will need to change the gap to zero on the bar chart. To do that double click on the series and choose the option tab.

  2. #2
    New Lounger
    Join Date
    Mar 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    shading date ranges (XP)

    <P ID="edit" class=small>Edited by WebGenii on 22-Mar-02 23:54.</P>I want to be able to shade date ranges in excel charts, and for the life of me I can't figure out how. I'm *sure* this is something in the manual, but I can't find anything in the help or on the web. Here's an example of what I want to do:
    http://www.dallasfed.org/htm/research/hot/bd0302.html (see figure 2)

    My goal is something similar, to shade the date ranges in which the US economy was officially in a recession. Does anyone have any ideas or suggestions?

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: shading date ranges (XP)

    Thank you! That works very well. I've already added this to about half a dozen graphs.

    I guess now my problem is, how can I get two lines with the date-shading bar graph in the background, all on the same axis?

    I guess this stems from the problem that I don't know how to change the graph type of an individual series without applying an entirely now graph type to the entire chart. I don't see any options under 'Format Data Series'. Am I looking in the right place?

  4. #4
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: shading date ranges (XP)

    I'm not sure how to change individual series either. It would make everything much easier. I was able to add another line by setting up the chart with one line series, then copying the data from the cells, and using paste special after the chart is selected to paste into the chart.

    In the paste special dialogue box select new series. I'm not sure why it's pasted as a line and not as a bar.

    I'm attaching the revisions, so you can always this one.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •