Excell Chart-how do I change all the lines and points without cha.

[ct]

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.

 

[Jon Peltier]

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]

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]

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/
_______