Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bar Chart Question (2003)

    My bar chart has three bars: Total Funding, Total Spent and Forecast Spending. Is there a way for the Forecast Spending Bar to show the difference (in red)between it and the Total Funding Bar?

    Thanks!

  2. #2
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Bar Chart Question (2003)

    Do you mean as a piece of text, a stacked bar or a fourth bar?

    Jim MacLeod
    Shetland Islands

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

    Re: Bar Chart Question (2003)

    Does the attached workbook do what you want? The chart is based on the region shaded pale blue, which is derived from the original data shaded pale yellow; it includes an empty dummy series.

  4. #4
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bar Chart Question (2003)

    I believe it would look like a stacked bar so is it a matter of somehow combining the two figures on one bar but the comparative bar would still stand on it's own in the chart. Does that make sense?

  5. #5
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bar Chart Question (2003)

    Hans, what a wonderful suggestion! That will suit my needs perfectly.

    Thank-you!

Posting Permissions

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