Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mz2
 
Posts: n/a
Default 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   Report Post  
Jon Peltier
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the color of all series in an excel chart in one go. Marielle Charts and Charting in Excel 2 May 3rd 23 07:45 PM
How can I display multiple series in a pie chart? AncientPC Charts and Charting in Excel 3 May 3rd 23 05:09 PM
Help! I'm losing one series of data in an overlay chart. Charts are Us Charts and Charting in Excel 1 January 4th 05 05:57 PM
One data series and two y-axes in an Excel chart? [email protected] Charts and Charting in Excel 1 December 30th 04 03:35 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 08:05 PM


All times are GMT +1. The time now is 09:31 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"