+ Reply to Thread
Results 1 to 2 of 2

Pie Chart

  1. 07-11-2009, 02:52 AM #1
    drusteeby
    drusteeby is offline
    Registered User
    Join Date
    07-11-2009
    Location
    Taylor, MI, USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Pie Chart

    Hi, I have Data set up like this, and I want a pie chart to add up the sums of the category's and tell me the percent of each category. I've been trying but cannot figure it out.



    Category Amount
    Food -$13.97
    Food -$6.41
    Transfer $120.00
    Food -$14.19
    Gas -$26.65
    Reply With QuoteRegister To Reply
  2. 07-11-2009, 03:18 AM #2
    se1429
    se1429 is offline
    Forum Contributor
    Join Date
    06-14-2008
    Posts
    153

    Re: Pie Chart

    Hi,

    First summarize the data using a pivot table, then plot the chart using the summary data.

    See this link:

    http://www.exceldigest.com/myblog/20...a-pivot-table/

    Regards.
    Welcome to: http://www.exceldigest.com/myblog/
    "Excel help for the rest of us"
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1