Results 1 to 3 of 3

Sub categories in pie charts

This is a discussion on Sub categories in pie charts within the Excel Questions forums, part of the Question Forums category; Hello, Can someone help me with what i hope is a simple query. I want to make a pie chart ...

  1. #1
    New Member
    Join Date
    Mar 2010
    Posts
    2

    Default Sub categories in pie charts

    Hello,
    Can someone help me with what i hope is a simple query.

    I want to make a pie chart and have subcategories.

    So for example, I have the following data in a spreadsheet:

    HTML Code:
    category	item	       amount
    home	        rent	       100
    essentials	food	        50
    insurance	pet	         5
    insurance	home	        10
    insurance	car	        50
    home	        carpet       	20
    So the pie chart would look kind of like this:



    Is that possible?

    Thanks! :D

  2. #2
    MrExcel MVP
    Moderator

    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    Blackboys, East Sussex, UK
    Posts
    10,039

    Default Re: Sub categories in pie charts

    Hello and welcome to the board.

    This article explains set-by-step.

  3. #3
    New Member
    Join Date
    Mar 2010
    Posts
    2

    Default Re: Sub categories in pie charts

    Thanks!!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com