+ Reply to Thread
Results 1 to 5 of 5

Show percentage difference between 2 lines in a chart.

  1. #1
    Registered User
    Join Date
    11-02-2017
    Location
    Denmark
    MS-Off Ver
    2k16
    Posts
    2

    Show percentage difference between 2 lines in a chart.

    Yo guys,

    I got a problem.

    I have a table with Revenue and Break-even Revenue. I have also calculated percentage differences...

    The problem is, that I have chart with revenue and break-even revenue and I don't know how to include percentages between the numbers....

    Chart1.png

    And I need to make something like this. To show difference between those numbers.

    Chart.png

    Thank ya,

    Vasary

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: Show percentage difference between 2 lines in a chart.

    Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
    (pictures of expected result - see also p2 below) are already posted)
    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

    3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

    To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.
    Best Regards,

    Kaper

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

    Re: Show percentage difference between 2 lines in a chart.

    This should get you going in the right direction
    http://andypope.info/charts/Hilolabel.htm
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    11-02-2017
    Location
    Denmark
    MS-Off Ver
    2k16
    Posts
    2

    Re: Show percentage difference between 2 lines in a chart.

    Quote Originally Posted by Andy Pope View Post
    This should get you going in the right direction
    http://andypope.info/charts/Hilolabel.htm
    Thanks, it's working!


    Quote Originally Posted by Kaper View Post
    Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
    (pictures of expected result - see also p2 below) are already posted)
    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

    3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

    To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.
    I have no idea what are you speaking about, sorry.

  5. #5
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: Show percentage difference between 2 lines in a chart.

    No problem, as Andy's suggestion worked fine.
    But if you have no idea -let me put some light on why I asked for attachment with sample workbook (of course I could prepare on, but you altlready did, when preparing screenshots.

    I believe it's fair if you (asking person) do all "family doctor/assistant/nurse work" (prepare patient for operation, collect documentation, may be even do anaesthesia, ... and we (those, who answer), we only do the real operation (well, may be also stitches )

    Anyway, as I said - now we are all happy, because "your patient" is in good health again

+ 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. [SOLVED] Formula to show percentage difference for one column and then items needed based on result
    By rhett7660 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-30-2016, 01:14 PM
  2. Show stoplight based on delta change AND percentage difference
    By maillemaker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2016, 10:30 AM
  3. [SOLVED] Calculate formula to show price difference & percentage
    By Coventry G in forum Excel General
    Replies: 6
    Last Post: 05-09-2016, 11:55 AM
  4. [SOLVED] Show percentage difference between cells in two columns on the same row.
    By StreekyD in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2014, 06:36 PM
  5. [SOLVED] show the difference between two cells as a percentage
    By ned 51 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-06-2014, 05:33 AM
  6. Show difference between values as a percentage
    By gkitf16 in forum Excel General
    Replies: 2
    Last Post: 08-31-2010, 12:12 AM
  7. How to show percentage difference in chart
    By jonhunt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-20-2007, 11:57 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