1 Excel sheet has attached, i want to display Pie graph in percentage by district wise and village wise.
1 Excel sheet has attached, i want to display Pie graph in percentage by district wise and village wise.
Last edited by maddyrafi1987; 09-26-2018 at 06:16 AM.
here would be one way. I put in an extra sheet where calculations are, some dropdowns and the pie graph will change by district or village name and by type of roof selected.
I didn't put in macros to hide the zeros because that is more work but that would be an extra that could be done.
for the dropdowns I used the developer tab and insert and combo box with references using vlookups and if then statements.
All work is visible on sheet1.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks