+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    06-03-2009
    Location
    melbourne
    MS-Off Ver
    Excel 2003
    Posts
    2

    Sequential series line chart

    Hi,
    I use Cognos to do reporting. I export a chart from cognos to excel and it produces the attached chart. Is there any way to create a sequential line chart, broken up into series like the attached chart?

    Any help with reproducing this chart using excel data would be appreciated.

    Thanks in advance.
    Johnnyg
    Attached Images Attached Images

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,944

    re: Sequential series line chart

    You just need to lay your data out correctly.
    Each series should have enough rows to cover the points on the x axis.
    But only have values for those points that require plotting.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-03-2009
    Location
    melbourne
    MS-Off Ver
    Excel 2003
    Posts
    2

    re: Sequential series line chart

    Thanks very much. Your response was perfect, once I worked out what you meant. It's easy when you know how !

    For others, I have attached a screen shot of the layout solution.

    Thanks again.
    Johnnyg
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

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.2.0