Need help with Excel 2007

Archived from the original Sajha.com — preserved as posted, replies can no longer be added here.
Start a New Discussion
Archived Post

I have a data in one column and want to make a pie chart using only that column. Example: Coulmn A 20 22 30 40 60 Want to create a pie chart with legends - 20-29, 30-39, 40 and above. Is it possible to put these column data in group in pie chart using those legends. ?

hicky · Oct 21, 2009 11:23 AM · 1,944 views

1 Reply

Before you could directly use pie diagram, first u need to make frequency table,  in a column , write the bins u need, ie 20,30, 40 . then next to it use frequency function, =frequency(data, bin), select all on right side then click in formula bar and press ctrl+Shift+enter, u will see a frequenct table then make pie diagram form it

shivanagar · Oct 21, 2009 12:00 PM

This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.

Start a New Discussion

You might be interested in...

Latest Community News View all
Page 1 of 9
Recent Classifieds View all
Page 1 of 28
Upcoming Events View all
Page 1 of 2
Service Providers View all
Page 1 of 21