+ Reply to Thread
Results 1 to 2 of 2

Chart Categories

  1. #1
    Registered User
    Join Date
    06-25-2009
    Location
    Marquette, MI
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Chart Categories

    Hello,

    I am having a charting category issue.

    I am building a monthly budget spreadsheet using Excel '07. I inserted a 3D pie chart highlighting C2:C37 (categories) and D2:D37 (withdrawal amounts) to visually illustrate how much I am spending on bills, gas, food, fast food, etc. However, I cannot get Excel to recognize multiple instances of "household/food" as a single entity and lump the corresponding totals into a single category, so I get a myriad of slivers representing individual purchases, as opposed to the broad categories I desire. Any suggestions?

    I am grateful for any help you may be able to offer.

    Attached is a screenshot of the chart in its present, useless form. (Pertinent private information has been blurred out.)

    Thank you!
    Flavor Dave
    Attached Images Attached Images
    Last edited by DonkeyOte; 06-26-2009 at 02:42 AM.

  2. #2
    Registered User
    Join Date
    06-25-2009
    Location
    Marquette, MI
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Chart Categories

    Never mind; found the solution in the PivotTable suggestion by Andy Pope in a thread towards the end of the page. Thanks!

    Call 'er solved, eh?

+ 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