+ Reply to Thread
Results 1 to 2 of 2

Display Pie graph in percentage

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    178

    Display Pie graph in percentage

    1 Excel sheet has attached, i want to display Pie graph in percentage by district wise and village wise.
    Attached Files Attached Files
    Last edited by maddyrafi1987; 09-26-2018 at 06:16 AM.

  2. #2
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,163

    Re: Display Pie graph in percentage

    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.
    Attached Files Attached Files
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1