Previous in Forum: PowerPoint 2007 - Referencing The Next Slide   Next in Forum: Ethiopian Kids Hack OLPCs in 5 Months With Zero Instruction
Close
Close
Close
8 comments
Rate Comments: Nested
Member

Join Date: Sep 2012
Posts: 7

PIE Chart

10/31/2012 3:52 AM

Hi,

I am intersted in making a report of system equipment in PIE Chart, where i am not able to show in Excel, would anyone suggest other source or guide me to do in Excel for represent the folowing in PIE graph.

where

POPULATIONNEW ARRIVALDEBUTREPLACED DUE TO FAILUREREPLACED DUE TO SYSTEMDEFECT OBSERVEDDEFECT RECTIFIEDDUE MAINTENANCEPREVENTIVE MAINTENANCE
24000501515201501258974
Register to Reply
Pathfinder Tags: PIE CHART MULTI LEVEL
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Guru

Join Date: Oct 2008
Posts: 42355
Good Answers: 1693
#1

Re: PIE Chart

10/31/2012 8:03 AM

The last time I looked you could chart with Excell.

Register to Reply
Guru
United States - Member - Lifelong New Yorker Popular Science - Biology - Animal Science Technical Fields - Technical Writing - Technical Writer

Join Date: Mar 2008
Location: NY
Posts: 2313
Good Answers: 59
#2

Re: PIE Chart

10/31/2012 9:23 AM
Register to Reply
Guru

Join Date: Aug 2005
Location: Hemel Hempstead, UK
Posts: 5826
Good Answers: 322
#3

Re: PIE Chart

10/31/2012 1:38 PM

Why do you say you can't do it in excel?

Select all the data:
Click on the chart tool icon:-

Choose pie:-

Next;
Next;
Enter title (I haven't bothered).
Finish.

Select all data except population column, and, repeat:-

In later versions of excel it will be less obvious what to do but I'm sure you'll get there.

Is that what you wanted?

__________________
If you spend all your time looking for people and things to complain about: trust me, you will find plenty to complain about.
Register to Reply Score 1 for Good Answer
Guru
Hobbies - CNC - New Member Hobbies - DIY Welding - New Member Engineering Fields - Electromechanical Engineering - New Member

Join Date: Aug 2007
Posts: 23647
Good Answers: 420
#4
In reply to #3

Re: PIE Chart

10/31/2012 2:06 PM

yes, now can you do the write-up for me!

I like it in power point!

btw, don't forget to put my name at the top.

nice response.

__________________
“ When people get what they want, they are often surprised when they get what they deserve " - James Wood
Register to Reply
Member

Join Date: Sep 2012
Posts: 7
#5
In reply to #3

Re: PIE Chart

11/01/2012 4:04 AM

Dear,

My requirement is not the usual chart, it something else, please see my chart made in regular Excel.

I want the above chart report in the following stacked format (i just got ths sample from net) If possible.....

I dont know how much it is easy... please help if possible

Register to Reply Score 1 for Off Topic
Guru

Join Date: Aug 2005
Location: Hemel Hempstead, UK
Posts: 5826
Good Answers: 322
#6
In reply to #5

Re: PIE Chart

11/01/2012 5:57 AM

By repeatedly creating new charts with reduced data sets you can certainly display the information in a clear way. In the example above I have just done the whole population, and, the subset of "not fully working" units. You may be able to get the visual presentation you're after in a later version of excel or you may need to search the net for specialist software.

__________________
If you spend all your time looking for people and things to complain about: trust me, you will find plenty to complain about.
Register to Reply
Guru
Hobbies - CNC - New Member Hobbies - DIY Welding - New Member Engineering Fields - Electromechanical Engineering - New Member

Join Date: Aug 2007
Posts: 23647
Good Answers: 420
#7

Re: PIE Chart

11/01/2012 8:03 AM

You can try this web site (Chandoo.org), very informative and they may already have a templete for you to use. Here they have an animated of hurricane Sandy.

http://chandoo.org/wp/

Search there site or put in a request or challenge.

__________________
“ When people get what they want, they are often surprised when they get what they deserve " - James Wood
Register to Reply
Participant

Join Date: Sep 2013
Posts: 1
#8

Re: PIE Chart

04/30/2014 5:00 AM

Not quite familiar with the chart making thing. However, I think in this situation you may try some UI chart tools, most of them contain the pie chart series feature. I imagine that be useful.

Register to Reply Off Topic (Score 5)
Register to Reply 8 comments

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Copy to Clipboard

Users who posted comments:

anthonyzz (1); lyn (1); Nassar (1); phoenix911 (2); Randall (2); SavvyExacta (1)

Previous in Forum: PowerPoint 2007 - Referencing The Next Slide   Next in Forum: Ethiopian Kids Hack OLPCs in 5 Months With Zero Instruction

Advertisement