charting 2 data series in succession

**Kimberly@TM** · 04-30-2009, 03:09 PM

I want to chart multiple sets of data in succession. i.e. FY2004-2008 as Series 1 and then FY2009-2013 as series 2. My intent is to get a graph that looks like Graph Sample A, I graphed it as one set of data and then manually changed the color of the second set of data, but what I want is to have the second set of data independant so that it shows up separate in the legend. Unfortunately, every attempt I've made gives me both sets of data on the same scale as in Graph Sample B and in this example I also lose half of my data points on the secondary axis. Does anyone have any suggestions?

samplegraphA.gif
samplegraphB.gif

Thank you

**Andy Pope** · 05-01-2009, 09:20 AM

You need to stagger your data layout.

For the column chart series set the Overlap value to 100

**Kimberly@TM** · 05-04-2009, 03:00 PM

I know I could do it that way, but, I don't really have the ability to put it in that format because we need to see the data in Excel format as well as on the chart. If I stagger the data, then I would have to change the format of the data. I'm trying to save time by not having to restructure the data just for the chart. In building the chart, I'm using the "select data" function and then creating multiple series. Does that make sense?

**Kimberly@TM** · 05-04-2009, 03:08 PM

Also, I'm not quite sure I know what you mean about setting the overlap value to 100. Could you expand on that a little more? I tried to read about it in help, but couldn't find a reference specifically to "overlap value".

Thanks

**Andy Pope** · 05-05-2009, 07:47 AM

double click 1 of the series to display format dialog.
on series option tab you can set the overlap value.

the quickest way to save time is to have the chart data laid out correctly for the chart. even if this means have 2 sets of data linked via formula

**Kimberly@TM** · 05-06-2009, 07:14 PM

I couldn't get it work by changing the overlap value. But, I hadn't thought of linking it to a separate set of data in the format I need. It's one of those things where my CEO says learn how to do this, then teach me. I may have to just set up all the linked values and charts for him and then he can just update his values in the original chart.

Thanks for the help.