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
Bookmarks