| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to change the color of all series in an excel chart in one go.
In Excel 2000
I have a chart (XY) with a large number of series. Excel assigns different colours to each series. I would like to have the same colour for all series and then change a few to highlight them. Do I have to change them all one by one or can I have excel make a chart where the series all have the same colour (preferably chosen by me)? |
|
#2
|
|||
|
|||
|
Marielle -
Format one series the way you'd like them all to look. Select another series, and press the F4 key to repeat, Select another and press F4 again, and continue until you've changed them all. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Mz2 wrote: In Excel 2000 I have a chart (XY) with a large number of series. Excel assigns different colours to each series. I would like to have the same colour for all series and then change a few to highlight them. Do I have to change them all one by one or can I have excel make a chart where the series all have the same colour (preferably chosen by me)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
| Help! I'm losing one series of data in an overlay chart. | Charts and Charting in Excel | |||
| One data series and two y-axes in an Excel chart? | Charts and Charting in Excel | |||
| Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Linear Mode
