Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
QUESTION- Simpler Way to Add a Data Series to Other Graphs? | Excel Discussion (Misc queries) | |||
HELP- Copy a Data Series to Other Graphs? | Excel Discussion (Misc queries) | |||
Format Data Series Markers | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |