Thread: 2 color bar chart?

I have a bar chart that has about 30 data points. The Y axis is a value and
the X axis is a name. There are two different possible categories in the X
axis. For example points could be "A 100" or "B 103" or "B 102" ...is it
possible to code the chart so that if a data point's label starts with "A"
format the bar one color... if not format it another?

Thanks for your time and any help you could provide!

http://peltiertech.com/Excel/Charts/...nalChart1.html

"John" wrote:

> I have a bar chart that has about 30 data points. The Y axis is a value and
> the X axis is a name. There are two different possible categories in the X
> axis. For example points could be "A 100" or "B 103" or "B 102" ...is it
> possible to code the chart so that if a data point's label starts with "A"
> format the bar one color... if not format it another?
>
> Thanks for your time and any help you could provide!