(Msg. 1) Posted: Wed Aug 06, 2008 1:57 pm
Post subject: Pie Charts Add to elertz Archived from groups: microsoft>public>excel>charting (more info?)
I need a pie chart to show quarterly data for 5 different departments.
Each quarter will display in it's own pie chart. Each of the 4
quarterly pie charts will be sized proportionately to the year end
total. A fifth pie chart will display the TTL data for each
department. Is this at all possible? Is there a better way to show
such data?
(Msg. 2) Posted: Fri Aug 08, 2008 5:10 am
Post subject: Re: Pie Charts Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Aug 6, 3:57 pm, valerie <vgar... RemoveThis @carletonls.com> wrote:
> I need a pie chart to show quarterly data for 5 different departments.
> Each quarter will display in it's own pie chart. Each of the 4
> quarterly pie charts will be sized proportionately to the year end
> total. A fifth pie chart will display the TTL data for each
> department. Is this at all possible? Is there a better way to show
> such data?
>
> Qtr 1 Qtr 2 Qtr 3 Qtr 4 TTL
> Dept 1 10 30 20 15 75
> Dept 2 15 25 25 20 85
> Dept 3 20 20 15 30 85
> Dept 4 25 15 8 30 78
> Dept 5 30 10 19 35 94
> 100 100 87 130 417
>
> Thank you in advance!
>
> V
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum