Sub categories in pie charts

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Sub categories in pie charts

  1. #1
    New Member
    Join Date
    Mar 2010
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    Blackboys, East Sussex, UK
    Posts
    10,597
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Sub categories in pie charts

    Hello and welcome to the board.

    This article explains set-by-step.
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

  3. #3
    New Member
    Join Date
    Mar 2010
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sub categories in pie charts

      
    Thanks!!

User Tag List

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