+ Reply to Thread
Results 1 to 3 of 3

Subject line: Pivot chart’s one line is correct but the other line not correct?

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    Subject line: Pivot chart’s one line is correct but the other line not correct?

    Hi Forum,


    The tab named “Sheet1” in the attached Excel file is having my input data.
    Using this data, I wanted to create 3 graphs to show how the % values of firm 1 and firm 2 behave in each quarter by 3 different cycles.

    I have created a pivot chart in tab named “Sheet2”.


    Q:
    Blue line in the graph (for Firm_1) is correct.
    But red line (Firm_2) is not correct. Red line looks like showing the combined values of (Firm_1 + Firm_2).

    Could you let me know how to correct the red line to correctly reflect its values which are 23%, 35%, 14% and so on.

    Thanks
    Mirisa
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Subject line: Pivot chart’s one line is correct but the other line not correct?

    Attachment 353175

    I believe the problem lies in the line chart type selected. I think that the selected line chart type is stacked, and that if you re-select line chart with markers you'll get the results you are looking for.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: Subject line: Pivot chart’s one line is correct but the other line not correct?

    Hi JeteMc,

    Yes, you are correct. It worked.

    Thank you very much for your reply.

    Regards
    Mirisa

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cant put correct cell as subject line in email
    By kwik98 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-15-2014, 03:22 PM
  2. [SOLVED] Data not generating on correct line
    By melnemac32 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2013, 11:32 AM
  3. [SOLVED] Creating a pivot line chart with no line.
    By ScottLor in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 04-08-2013, 10:38 AM
  4. Unable to pull the correct data into Line Chart.
    By LunarLights in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-19-2013, 05:44 AM
  5. eduation trend line not correct
    By ghislain in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-22-2007, 05:11 AM

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