+ 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 Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    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

  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)

Similar Threads

  1. Replies: 2
    Last Post: 10-16-2014, 08:57 PM
  2. Comparative chart for volume and price
    By Aman Bains in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-06-2013, 04:50 PM
  3. Replies: 7
    Last Post: 08-13-2013, 12:26 AM
  4. Making comparative chart
    By karjan07 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-20-2012, 05:35 AM
  5. Want to create comparative pie charts in same chart
    By Grasor in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-04-2009, 08:20 PM
  6. Comparative Weight Loss track chart
    By tsunimee in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-23-2009, 09:26 AM
  7. Depict relationship via Charts in Excel
    By mtlfire in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-01-2005, 04:33 PM

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