Pie chart query

[AbhijitV]

I am requesting help for the enclosed data. I want to create pie chart with two dimensions, Agencywise and facilitywise in a single pie chart

Please do the needful and revert on priority basis


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[Hui]

like this?


see attached file:

 

[AbhijitV]

Mr Hui,

Thanks for the reply, will you please explain how you have worked out this chart? Can i put nos on the chart?

 

[Hui]

I selected the Data
Then made a Pie Chart
Then Copied the Pie Chart
and went to the Chart Tools, Design Tab and selected Switch Rows/Columns,


Then Select a Pie Ring, Right Click add Data Labels
Yes you can have numbers there, or percentages etc

 

[AbhijitV]

Thanks Mr Hui for your help, but i can't see pie rings after switch row column. I am presently using excel 2010. Is it available in the new versions only