+ 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
    239

    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 Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    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)

Similar Threads

  1. Replies: 5
    Last Post: 03-09-2018, 05:28 AM
  2. Replies: 0
    Last Post: 10-03-2014, 07:51 AM
  3. Replies: 0
    Last Post: 09-15-2014, 02:01 AM
  4. Replies: 3
    Last Post: 09-14-2012, 11:59 AM
  5. Replies: 2
    Last Post: 08-29-2011, 12:29 PM
  6. Replies: 6
    Last Post: 01-25-2006, 02:45 PM
  7. Hyperlinkage of one graph with another graph or Drill down graph
    By Sanjay Kumar Singh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-03-2006, 08:25 AM

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