If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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? ... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Scatter chart without connecting lines? | BatGrrrL | Charts and Charting | 3 | November 23rd, 2004 01:56 PM |
Lines on Chart border (bug!?) | routeram | General Discussion | 1 | September 22nd, 2004 02:24 AM |
Excel Chart Vertical Lines Corrupting? | Ken Black | Charts and Charting | 4 | June 4th, 2004 09:16 PM |
Area chart with vertical lines | Andy Pope | Charts and Charting | 0 | February 4th, 2004 12:35 PM |
lines between data points | Steven M | Charts and Charting | 1 | December 16th, 2003 03:48 PM |