• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chart color per label

M

mr_hiboy

Member
Hi,


Hope someone can help here.


I have a bar graph that has 5 bars, say Product1 - 5. The data is order best to worst performing and depending on the data selection Product 1 may appear top or bottom, therefore moves on the chart.


I want each product (bar) to be a specific colour, i.e. product 1 always green. But i can only seems to make the first bar green, but isn't always product 1.


If that makes sense?


cheers
 
Mr Hiboy


Select the Chart

Then select the series

Then select a Single Bar by clicking one

Then select a Fill Color from the Home Tab

Use the Right/Left arrow keys to select different bars
 
Hi Hui, thanks for the quick response.


That's what I was trying but when the data changes, the bars are reorder depnding on results. Therefore the first bar which was green stays green when in fact the product/bar has moved.


thanks
 
To do what you want you will need a series for each bar

Each bar will have a series of N/A# errors except for the value where the bar is

each series will have a different color


If you post your data I'll mock it up

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Have a look at:

https://www.dropbox.com/s/qqvprsrny6kttev/Summary%20Temp_Hui.xlsx
 
Actually it still doesn't work.


example, firstly i made the product 1 bar bright yellow (easy to follow). if you make the value of product 1 a higher number (e.g. 20000), then sort by YTD. Product 1 moves but when you look at the graph the first bar colour is bright yellow but it product 2.


I'm hoping that product 1 would stay bright yellow.


Cheers
 
Mr Hiboy


If you put the product names across the top of teh data in Row D6:AA6 and

then in D7 put

=IF(D$6=$A7,$B7,NA())

Copy across and down

problem solved


or download here: https://www.dropbox.com/s/h1ib5bavom33fyk/Summary%20Temp_Hui2.xlsx
 
You must log in or register to reply here.
Back
Top