+ Reply to Thread
Results 1 to 3 of 3

Pivot Chart adding data together in line chart

  1. 07-11-2013, 04:57 AM #1
    jennieS
    jennieS is offline
    Registered User
    Join Date
    03-19-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    20

    Pivot Chart adding data together in line chart

    Hi,

    I've got a pivot line chart which needs to show 2 lines of data, however the second data series gets added to the first. Example attached. How can I stop this happening? It won't let me select and edit the data series as you can in a normal chart

    Thanks!
    Attached Files Attached Files
    Last edited by jennieS; 07-11-2013 at 05:38 AM.
    Reply With QuoteRegister To Reply
  2. 07-11-2013, 05:20 AM #2
    JosephP
    JosephP is offline
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Pivot Chart adding data together in line chart

    right-click the chart and change its type to 'line with markers' rather than 'stacked line with markers'
    Josie

    if at first you don't succeed try doing it the way your wife told you to
    Reply With QuoteRegister To Reply
  3. 07-11-2013, 05:37 AM #3
    jennieS
    jennieS is offline
    Registered User
    Join Date
    03-19-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Pivot Chart adding data together in line chart

    Thank you, I had a feeling it would be that simple!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1