ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Different color for data sub-set for bar chart. (https://www.excelbanter.com/charts-charting-excel/88917-different-color-data-sub-set-bar-chart.html)

Peter St. John

Different color for data sub-set for bar chart.
 
I have created a vertical bar chart with 2 bars for each of 5 years showing
comparison data. For the first year, I would like to have the color of one
of the bars different from the color in the subsequent 4 years to show
special program initiation. Is there a way to do this?
--
PStJ

Jon Peltier

Different color for data sub-set for bar chart.
 
Click on the series, then click on the point, then select Selected Point
from the Format menu.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"Peter St. John" wrote in message
...
I have created a vertical bar chart with 2 bars for each of 5 years showing
comparison data. For the first year, I would like to have the color of
one
of the bars different from the color in the subsequent 4 years to show
special program initiation. Is there a way to do this?
--
PStJ





All times are GMT +1. The time now is 05:15 AM.

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