Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jun 2002
    Location
    Worthington, Ohio, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Charts (Excel 2000)

    If I have a sales goal of $10,000 and my actual sales are at $5000, how would I get a 3-D bar chart to shade in the bar to the $5000 line instead of adding it to the to of the bar? Kind of like a progress chart.

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Charts (Excel 2000)

    You could add a calculated value Goal - Actual, and create a stacked bar chart from Actual and Goal - Actual. See attached.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts (Excel 2000)

    Create a separate data series for Actual and Goal.

    Right click on the Goal column. Under "Format Data Series", assign Goal to the secondary Y axis. I've also adjusted the width of the Goal column by adjusting the "Gap Width".

    Make sure your secondary y axis has the same scale as your primary y axis.

    See attached example.

Posting Permissions

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