+ Reply to Thread
Results 1 to 3 of 3

Right chart to depict comparative data which may or may not have -ve data

  1. #1
    Registered User
    Join Date
    12-14-2005
    MS-Off Ver
    2016
    Posts
    12

    Right chart to depict comparative data which may or may not have -ve data

    Hi

    I have run into a problem while creating charts for the sample data attached. I need to be able to compare all regions along the parameters given (ideally using one chart)
    However, the margin parameter is calculated basis the values in the other parameters and can be -ve. I tried using a pie chart and stacked chart. However, the pie chart considers the -ve margin value as positive and plots accordingly. The stacked chart is better, but it does not plot the regions with -ve margin values properly as can be seen in the graph. Ideally, even for regions with -ve margins, the stack should go upto 100% but it does not do so. Am i missing something here?

    The other possible way of doing this graph is to plot everything as a +ve value and if the actual margin is -ve, plot the value above 100 with a different color. Illustrated in the workbook attached.

    I am open to other ideas/charts which can depict this comparative data easily.

    Any suggestions

    Thanks and Regards
    Pradeep
    Attached Files Attached Files

  2. #2
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    8,606

    Re: Right chart to depict comparative data which may or may not have -ve data

    Administrative note
    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

  3. #3
    Registered User
    Join Date
    12-14-2005
    MS-Off Ver
    2016
    Posts
    12

    Re: Right chart to depict comparative data which may or may not have -ve data

    Hi

    Updated the office version.

    Also, found that i was using a wrong chart type. Changed it to Stacked bar from 100% stacked bar.

    Thanks

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1