ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to assign individual colours to each bar chart? (https://www.excelbanter.com/charts-charting-excel/143225-how-assign-individual-colours-each-bar-chart.html)

sparjolly

How to assign individual colours to each bar chart?
 
I would like to draw a bar chart with individual colours for each bar. The
option "vary colours by points" is shown in grey and cannot be seected.

Jon Peltier

How to assign individual colours to each bar chart?
 
You can format the bars individually. Select a single bar by single clicking
it to select the series, and single clicking it again to select just the
bar. Then double click to open the Format Point dialog, which will format
just this bar. With one bar selected, you can use the left and right arrow
keys to select a different bar.

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


"sparjolly" wrote in message
...
I would like to draw a bar chart with individual colours for each bar. The
option "vary colours by points" is shown in grey and cannot be seected.





All times are GMT +1. The time now is 06:09 PM.

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