Marker and Line Color Options in Excel Line Graph

**Slmoore** · 03-20-2013, 03:56 PM

Hello-

I have seveal Line graphs with the same chart layout. They currently use the automatic settings for both the marker and line color options, but for some reason, the legends do not start with the same marker or color for each chart. I would like to make them all the same, so that they are easy to compare. For example. data for 2012, might be a blue line with a circle marker on one chart, but a green line with a square on the next. Does anyone know a quick way to correct this so they are all the same? At this point I don't care what color/ marker is used as long as they are all uniform.

I'm using Excel 2007, and the data is on a different tab than the charts.

**JosephP** · 03-21-2013, 03:23 AM

are you plotting the series in different orders on each chart?

**Slmoore** · 03-21-2013, 11:11 AM

Thanks for responding. They are in the same order for each chart.

**JosephP** · 03-21-2013, 11:41 AM

were they always in the same order or have some been rearranged? also are all series of data visible on all charts?

you could set the formatting to a manual setup for each series on each chart using some code-can you post a sample workbook?

**Slmoore** · 03-21-2013, 12:55 PM

Sample.xlsx

I'm not certain if they have always been in the same order (I modified a document that was given to me by a co-worker).

I've attached a sample, there are several excel documents with the same layout, each containing multiple tabs. For each chart, the data is located in a seperate tab as seen in the sample. The only difference is the item referred to in the sample as "local" (and the data of course) is different for each chart.