Bar Chart Colors based on Label Name!

**troilii** · 01-29-2016, 04:18 PM

Hi, so here's the thing. So far I have used VBA for coloring my bar charts based on value criteria. e.g. if bar is > 0.25 then green. Not I need to use the same thing based on the label name. E.g. if the label says "Troi" color bar green, if it says "Person 14", color bar red and if there is a "*" before a person e.g. "*Troi", then color bar yellow.

Anyone has any ideas or something on their mind? - Any info much appreciated!!!

Thanks a lot!

**troilii** · 01-30-2016, 08:36 PM

UP!

Maybe someone has some ideas?

Bar Chart Colors based on Label Name!

LinkBack

Thread Tools

Rate This Thread

Display

Bar Chart Colors based on Label Name!

Re: Bar Chart Colors based on Label Name!

Thread Information

Users Browsing this Thread

Similar Threads

Slow VBA code: Protecting cells based on colors while changing colors based on cell change

Stacked Chart - Change Bar Colors Based on Date (X-Axis)

[SOLVED] Paste/ Move picture based on Chart data label

Excel column chart colors based on values of a different series

Set bar chart colors based on data?

[SOLVED] chart label reference based on the column number

RE: chart label reference based on the column number

Bookmarks

Bookmarks

Posting Permissions