Results 1 to 5 of 5

Thread: Excel chart

  1. #1
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    95
    Thanked 14 Times in 13 Posts
    I am creating a chart that is showing potential cost savings. I've created a stacked column chart with two columns. The first column is existing costs and the second column is costs after the potential savings. The potential saving is 30 to 50%.

    Presently the second stacked column is displaying two different colors for the upper and lower parts as usual.(ie the first column shows $100 present cost, the second column has a total height of $70, with the upper $20 in a different color, representing that costs could range from $50 - $70.)

    But because the potential savings is a range rather than an exact number, I'd like the upper part of the second column to be either cross hatched or transparent, or some other effect to represent the unknown nature of the exact amount. But I cannot find any way in Excel 2007 to format the way the upper part of the column appears.

    Is there a way to do this, or is there some other type of chart I can be using to represent this data?

    Thanks

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Pattern Fills were removed in 2007.

    But you could use Andy Popes Add-In Here
    Andrew

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If you use a solid fill, you can make it transparent in the Format series dialog.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    95
    Thanked 14 Times in 13 Posts
    The transparency worked fine!

    Thanks

  5. #5
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    95
    Thanked 14 Times in 13 Posts
    Andrew,

    Thanks for the tip about the pattern fillls, I may give that a try in the future.

Posting Permissions

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