Vary bar colors by bar

G

Guest

I would like to vary the colors on a bar chart by bar.
The chart plots 7 points agains a standard.
The standard has the value of 100.
The points change based on information received weekly.
This will cause the bars to, sometimes, be above the standard and,
sometimes, below the standard.
How can I force the bars to change colors with every update so that when the
bar goes over the chart it will be green but when it falls below the chart it
will be red?

Tim
 

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

Top