Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ct
 
Posts: n/a
Default Excell Chart-how do I change all the lines and points without cha.

In MicrosoftExcell Chart
How do I change all the lines and markers in a graph to be the same without
changing each individual data series.
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Change them how? Change formatting? Select each marker (two single clicks, one for
the series, one for the marker) to format the marker and line preceding the marker.
Change the data? Either change the data in the cells, or you have to change which
cells each series refers to (Chart menu - Source Data - Series tab).

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

ct wrote:

In MicrosoftExcell Chart
How do I change all the lines and markers in a graph to be the same without
changing each individual data series.


  #3   Report Post  
ct
 
Posts: n/a
Default

Thank you for the response.
However the problem I have is thet my graph has 21 series; each is plotted
as a separate line with 4 points (markers). Excell automatically give each
series a different line colour and point marker. I want all the lines and
markers to be identical, but can only do this by moving through each series
in tern and changing the line and marker attributes.
Is there a quicker way?

Carl

"Jon Peltier" wrote:

Change them how? Change formatting? ...

  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default

Hi Carl -

Is there a quicker way?


Yep. Change the first one. Select the second and press the F4 key ("Repeat"). Select
the third and press F4, etc.

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

ct wrote:

Thank you for the response.
However the problem I have is thet my graph has 21 series; each is plotted
as a separate line with 4 points (markers). Excell automatically give each
series a different line colour and point marker. I want all the lines and
markers to be identical, but can only do this by moving through each series
in tern and changing the line and marker attributes.
Is there a quicker way?

Carl

"Jon Peltier" wrote:


Change them how? Change formatting? ...


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



All times are GMT +1. The time now is 11:56 PM.

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

About Us

"It's about Microsoft Excel"