Pie charts

  • Thread starter Thread starter Dave Shultz
  • Start date Start date
D

Dave Shultz

I am trying to use the Pie of Pie chart to represent the
data below. I want the pie chart on the left to show PS,
Unspecified, ECP and a sum of AHD status. And the pie on
the right will show the breakdown of the AHD status. How
do I do this?

Status Total
ECP 2
PS 287
Unspecified 45
AHD Analysis Complete 18
AHD Analysis in Progress 461
AHD Closed 317
AHD Implemented 109
AHD Work Assigned to Resource 24
AHD Work Authorized 35
 
[This followup was posted to microsoft.public.excel.charting with an
email copy to Dave Shultz.
Please use the newsgroup for further discussion.]

Select all the data of interest, and create a pie-of-pie chart. Then,
double-click the plotted pie chart and in the Options tab, set the
'Second plot contains the last' X values as desired (6 in your
example).

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top