PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting multiple pie charts on same graph

Reply

multiple pie charts on same graph

 
Thread Tools Rate Thread
Old 15-11-2007, 09:19 PM   #1
=?Utf-8?B?Qm9yaXNT?=
Guest
 
Posts: n/a
Default multiple pie charts on same graph


I need to have two pie charts in one overall chart in '07? They are
completely separate data sets (common categories), and so I cannot have the
"pie of a slice" which I see, unless I can use a zero value for one slice of
the main, and then divide that into 100% somehow (in which case it doesn't
show up in one, and the subslice ends up being pie number 2).

I have to have it this way for printing/file purposes.

Any help? Thx.
--
Boris
  Reply With Quote
Old 16-11-2007, 12:47 AM   #2
Tushar Mehta
Guest
 
Posts: n/a
Default Re: multiple pie charts on same graph

Create two pie charts and position them next to each other. You can
always format the result to look like a single chart. For an example
you should be able to adapt see
Stacked Charts
http://tushar-mehta.com/excel/newsg...arts/index.html


In article <73EBE1DE-105C-4BAC-A10D-D4A20B2F988D@microsoft.com>,
BorisS@discussions.microsoft.com says...
> I need to have two pie charts in one overall chart in '07? They are
> completely separate data sets (common categories), and so I cannot have the
> "pie of a slice" which I see, unless I can use a zero value for one slice of
> the main, and then divide that into 100% somehow (in which case it doesn't
> show up in one, and the subslice ends up being pie number 2).
>
> I have to have it this way for printing/file purposes.
>
> Any help? Thx.
>

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off