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
Bookmarks