ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I color specific data series based on location on data she (https://www.excelbanter.com/charts-charting-excel/33328-how-do-i-color-specific-data-series-based-location-data-she.html)

Havard

How do I color specific data series based on location on data she
 
I have about 150 data series in a chart and I want to color e.g. 10 of them
red based on where in the data sheet they are located, e.g. data i column J
to T. Is there an easy way to do this?

Barb Reinhardt

Format one of them the way you want. Select the other series you want to
change and press F4. This may be difficult with 150 series, however.

"Havard" wrote in message
...
I have about 150 data series in a chart and I want to color e.g. 10 of

them
red based on where in the data sheet they are located, e.g. data i column

J
to T. Is there an easy way to do this?





All times are GMT +1. The time now is 08:32 AM.

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