Chart

[KVAMSHE]

Hi Chandoo,


I need your help in solving my problem which am facing & trying from past one week to find a solution.


About the problem:


I have a employee database which consists of Managers, Executives,Permanent & Temporary etc. Same data i have kept in pivot table which has given me the desired view there after i have inserted stacked column chart and selected data range. In the chart am able to see managerwise how many Permanent & Temporary executives are working but not able to find grand total/total at each manager level even though it was there (calculated automatically) in pivot table. I tried to select data range but it is disabled.


My requirement is that i want to show that each manager is having how many permanent & temporary excutives and also total executive- could you please give me a solution to my issue (either stacked or anything other chart).


Thanks in advance


Regards,


Vamshe

 

[Hui]

Vamshe


Firstly, Welcome to the Chandoo.org forums.


Can you please post a sample file for us to see your data

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[Suchu]

Hi Vamshe,
I found an app that can help you. Especially since you already have your data in pivot table format. You can import your spreadsheet, choose the x and y axis, and choose "count" to see your totals. Hope this helps you.

Cheers,
Susan