Showing Sum and Parts total in same Chart

[Anil Kulkarni]

I have a very simple chart to make but looking for the best option.
I have 3 values - Total, Sum of A, Sum of B. Values A + B = TOTAL.
What will be the best way to show it so that we can see a TOTAL's Bar (or any other shape) and show the A and B as part of that Total?

As an example: Total = 81, Sum of A = 49 and Sum of B = 32

Thanks
Anil

 

[NARAYANK991]

Hi Anil ,

Isn't the Stacked Column or Stacked Bar for this ? Have you tried it out ?

Narayan

 

[Hui]

As Narayan said try a Stacked Column chart, but you'll only need to chart A and B as the two will be stacked and the total will be shown as the height of the combined two

 

[Anil Kulkarni]

The Stacked one is not giving me what I need. I need to show the Total as a Distinct value and show the other 2 as parts of that. It is probably more to do with 'how to show'. Once we get that visualization, I will have a question on 'how to do' . As in - should it be a Pie Chart with a circle for the total number and slices for the parts? Or shoudl it be a bar chart with the biggest bar for the Total and smaller ones for the sub totals.
Hope you can guide.

 

[Anil Kulkarni]

Thanks Hui. I was looking for showing distinct values as opposed to stacked in one Bar. Hope that clarifies. Have given more details in previous post.