Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|