Results 1 to 6 of 6

charting 2 data series in succession

Threaded View

  1. #1
    Registered User
    Join Date
    04-29-2009
    Location
    Sebastopol, CA, USA
    MS-Off Ver
    Excel 2007
    Posts
    15

    charting 2 data series in succession

    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
    Last edited by Kimberly@TM; 05-06-2009 at 07:20 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1