ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   2 color bar chart? (https://www.excelbanter.com/charts-charting-excel/78994-2-color-bar-chart.html)

John

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!

John

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!



All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com