WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Pie Charts

 
   Home -> Office -> Charting RSS
Next:  Charting: Want to display value and difference on one chart  
Author Message
valerie

External


Since: Apr 18, 2008
Posts: 5



(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?

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
Back to top
Login to vote
valerie

External


Since: Apr 18, 2008
Posts: 5



(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


I have found a solution. Thank you.

V
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> Charting 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
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET