+ Reply to Thread
Results 1 to 2 of 2

Auto-Generating a pie chart based on different columns

  1. #1
    Registered User
    Join Date
    07-18-2016
    Location
    Albany, New York
    MS-Off Ver
    Office 365
    Posts
    1

    Auto-Generating a pie chart based on different columns

    I would like to create a pie chart that will take into account the date, classification, and value of a set of data. I have 3 columns: One stating the date, one stating the cost, and one classifying it as a (want/need/other), How can I create a pie chart that gives me the percentage of my spending that is a want/need/other for a specific date range (e.g. July)? Thank You.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,925

    Re: Auto-Generating a pie chart based on different columns

    If you can post a sample workbook with some sample, non-sensitive data, we can probably help you better. Thanks.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. [SOLVED] Help with auto generating numbers (as a text) based on a value
    By agl4 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2014, 06:42 PM
  2. Auto generating emails based on date in cell
    By Snaga in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2014, 12:41 PM
  3. Replies: 5
    Last Post: 12-05-2012, 12:07 PM
  4. auto generating number based on information from other cells
    By cody1187 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 02-21-2012, 02:27 PM
  5. Auto-Generating Entries based on combined Entries
    By Ice Burn in forum Excel General
    Replies: 3
    Last Post: 09-12-2011, 05:52 AM
  6. [SOLVED] need to format chart columns based on info not displayed in chart
    By papa jonah in forum Excel General
    Replies: 0
    Last Post: 03-21-2005, 05:06 PM

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