code to assign colors to chart

D

deb

Is it possible to code a chart so that if the data is a 1, make the color of
the pie chart section red and if the data is a 0 make the color of the pie
chart section green?

The data is a count of 1's or 0's.

Currently if the data count is all 0's (100%) the whole pie is green and
if...
the data count is all 1's (100%) the whole pie is still green. If the data
is all 1's I need the pie to be red.

Is there a way to program, if data to be counted is 1's make red, if dat to
be counted is 0's make green???

It's making me crazy. I don't like charts.
 

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

Excel Graphing 4
Pie chart segment colors using VBA? 1
Custom Chart Options 0
How can I make a "Clock" chart in Excel 0
VBA - (re-) Set a Table Style 2
setting graph series colours? 1
Visio 2013: how do I auto-colour Shapes in alignment with pre-entered Shape Data? 0
Specific colors in a pie chart 3

Top