+ Reply to Thread
Results 1 to 4 of 4

Graph is doubling the total amount

  1. #1
    Registered User
    Join Date
    04-28-2020
    Location
    Jacksonville, FL
    MS-Off Ver
    16.0.11328.20492 32-bit
    Posts
    9

    Graph is doubling the total amount

    I made a graph to track the total number of things per day, including an overall total. The problem is that the total is double the correct amount. How do I fix this?
    Attached Files Attached Files
    Last edited by RH6978; 07-16-2020 at 04:10 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Graph is doubling the total amount

    I don't know much graphs but I did look at the wb you supplied. There is a primary and secondary for that top line. When you select primary, it doubles, select secondary and it is correct. I don't know what that means, it's just what I noticed.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,812

    Re: Graph is doubling the total amount

    The line is correctly positioned for the chosen chart type -- a stacked line. Were you expecting to use a regular line chart?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    04-28-2020
    Location
    Jacksonville, FL
    MS-Off Ver
    16.0.11328.20492 32-bit
    Posts
    9

    Re: Graph is doubling the total amount

    That was the dang issue - didn't realize I selected that type. Thanks!

+ 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. formula for deriving taxable amount from total amount.
    By rajdh75 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-01-2020, 06:41 PM
  2. total amount due
    By toddp2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2019, 12:53 PM
  3. Replies: 5
    Last Post: 12-08-2016, 04:24 AM
  4. Graph a certian amount of numbers
    By dustinh48625 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-08-2013, 10:27 PM
  5. how to work out rate based on total time and total amount
    By lisaathers in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2013, 06:44 AM
  6. Graph amount of activity over time
    By Verve19 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-24-2013, 04:56 PM
  7. [SOLVED] How do I calculate Amount of Sales Tax from Total Amount?
    By MikeS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2005, 04:06 PM

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