format colors on bar charts by value

B

BillC

I'm working on a Bar chart with 5 bars. What I would like to do is change
the color of each bar depending on the number it is graphing. My table is
very simple, column A is the data names, column B are the values from 0 to 3.
If the value is 1 I would like it to change the color of the bar to red, if
it is 2 I'd like it to change to yellow, if it is 3 I'd like it to change to
green.

Can this be done?

Thanks
Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems with my label templates 0
Bar Chart with Data Elements 1
Remove title bar and phase bar by default on swimlane 0
Change the colour of a neighbouring cell 6
How to make scroll bar permanently visible, Word 365 0
Paragraph numbering in Word 1
Chart Formatting 1
Doughnut Chart linked with the slicer in the pivot table 0

Top