+ Reply to Thread
Results 1 to 2 of 2

Fill of bars in barchart

  1. #1
    Registered User
    Join Date
    01-21-2011
    Location
    BC, Canada
    MS-Off Ver
    Excel 2011 for Macs
    Posts
    2

    Fill of bars in barchart

    Is there a way to set colour-fill limits at different points along the Y- axis of a bar chart, so that my bars will be coloured in proportionally to those limits? (ie. on Y-axis I want 0-200 to always show up as white, 201-400 to always show up as green, 401-600 to always to show up as black across my entire data set. So if I have data that has a value of 600, it will be coloured in 1/3 white, 1/3 green, 1/3 black. If I have data that has a value of 400, it will be coloured in 1/2white and 1/2 green only? If I have data that has a value of 200, it will only be coloured in white?
    THanks!

  2. #2
    Forum Contributor
    Join Date
    02-14-2007
    Location
    Chester, England
    MS-Off Ver
    2010 & 2016
    Posts
    312

    Re: Fill of bars in barchart

    Hi

    I have attatched a picture of how I think you could set up this type of chart (I dont have a mac so not sure if you could open an example sheet)

    If you set up your sheet with the totals broken down into the sections you described then add it as a stacked bar chart, you can then colour each section as required.

    It may be a long winded way of doing it but it is the best I can come up with.

    Hope this helps

    Cheers

    Jim
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1