View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
John
 
Posts: n/a
Default 2 color bar chart?

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!