Stacked bar Chart with Base Data

[Debraj]

Hi Forum,

Need a 100% Stacked Column Chart
Need to add data label like 40% & 60% for each series
Need to Display Total No Of Post in Right Axis or Secondary Axis

PS: Feel free to change chart type.. If required.

Sample file 7 expected Output attached..

 

[Luke M]

Hi Deb,

Interesting idea for the chart. I think this is what you are looking for.

 

[lohithsriram]

Hi Deb,

This video pretty much talks about your requirement. Hope this helps.

Just that you need to show the Secondary Axis and define the minimum and Maximum units of it with the TotalPost values.

 

[Somendra Misra]

@Luke M ....Thanks for sharing your knowledge & specially linking of data labels to other cells, all these days I was doing this with title.
@Debraj ... Thanks for putting this challenge.

Regards,

 

[Debraj]

Hi Luke..

Exactly this is what I am looking for.. Thanks.. and easily applied..
Due to "I_Need_This_now" type approach from Boss... I Applied a Dummy series in Secondary axis.. and displayed DataLabel in the Bar itself.. already submitted.. but now learned..


Hi Lohit..
I am in Company network.. No access to many of the site.. will check later..

 

[Debraj]

@Luke M ,

Did you manully clicked each Label and in Formula bar write "=A1" for each label..
or

Add labels to dummy series, link to Total Post column

can you Please re-elaborate this line.

 

[Luke M]

You can do that, but I use an add-in. First learned about the overall technique here:
http://peltiertech.com/WordPress/link-chart-text-to-a-cell/

and I use John Walkenbach's chart tools add-in. I don't think John still has to tool visible on his site, but the alternative one is available. Alternatively, it makes for a fun VBA challenge to try and write you own.

 

[Luke M]

Looks like I can upload a Zip file. The zip file contains John's add-in, if you want to use it.

 

[juanito]

From the dataviz perspective and the dataset, I'm wondering why you choose 100% stacked bar over normal stacked bar, where the overall volume is graphically displayed as well as the proportion between types.

Maybe because you changed the dataset in the example file? Or do you still consider 100% as more appropriate?

- juanito