Hi,
We have a requirement where we need to show the bars of a column graph in color, in three colors actually. If the value of the cell is between 0-50, the bar has to be in red. If the cell value is between 51-70, the bar has to be yellow and if the cell value is between 71-100, the bar has to be in green.
Does anyone know how to do this (preferably without using VBA).
Thanks in advance
SBRS
Use multiple series.
Set the Overlap property to 100.
use formula to populate 1 of the multiple series depending on the value and the colour data ranges.
There are many examples on forum if you search for 'Conditional chart'
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks