+ Reply to Thread
Results 1 to 3 of 3

Help! Area chart is showing my data wrong!

  1. #1
    Registered User
    Join Date
    04-09-2016
    Location
    Massachusetts
    MS-Off Ver
    Office 2007
    Posts
    2

    Question Help! Area chart is showing my data wrong!

    I'm trying to create one area chart that is the combination of these two graphs. The data sets are one that is all positive numbers and the other is all negative numbers. This is the area charts individually:
    chart1.jpg
    However when I try to highlight both data sets and say build a single area chart I get this which clearly is it adding and subtracting the numbers from themselves:
    chart2.jpg

    What is really unusual is that if I switch this to column chart, then it works fine and the data looks as it should in column format which is hard to read.

    chart3.jpg


    And if you are wondering what the data looks like, here is both of the tables:
    chart4.jpg

    So can anyone help me to make one chart of data that is not being merged together but to remain as in the initial two graphs?

    Any help would be really really appreciated
    Thanks
    David

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: Help! Area chart is showing my data wrong!

    You have 2 choices.

    Create a dummy series to force the positive scores back to zero.

    Or plot all the positive series on one axis and the negative on the other. The format both axis to have same min/max values
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-09-2016
    Location
    Massachusetts
    MS-Off Ver
    Office 2007
    Posts
    2

    Re: Help! Area chart is showing my data wrong!

    Thank you! I will try that

+ 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. Bar chart with wrong area
    By AmalieM in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-06-2015, 08:16 AM
  2. Excel Chart Showing Wrong Month
    By rtabaldi in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-19-2013, 05:25 AM
  3. Line Graph showing wrong data
    By kevin2184 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-01-2011, 10:59 AM
  4. Excel 2007 : Chart showing wrong if cell is blank
    By sherifpv in forum Excel General
    Replies: 6
    Last Post: 05-31-2011, 03:49 AM
  5. Pivot table showing wrong data (date not month)
    By rushdenx1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2010, 06:59 AM
  6. Plot 3 sets of data in scatter chart and area chart in one
    By geoffs52 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-24-2009, 04:42 AM
  7. [SOLVED] excel chart plot area not showing data
    By samm in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-25-2005, 07:05 AM

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