Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Excel - Chart needed to summarise data

2 replies to this topic

#1 Julia-the-PCGP

Julia-the-PCGP

• Members
• 38 posts
• OFFLINE
•
• Gender:Female
• Location:Streatham Hill
• Local time:11:06 AM

Posted 21 May 2012 - 02:23 AM

A friend has asked me to help him solve an urgent Excel problem and I do hope you can help quite quickly as he has to give a presentation at 11am !

He has a long list of data (approx 700 lines of data in a single column) where data is in units of 6 (ie: 6, 12, 18, 24, etc) and I want to create a pie chart showing the total percentage for each of these 6 unit values - eg: so it is easy to see on one
chart that 54% are 6, 21% are 12, 9% are 18, etc

Can you provide easy to follow instructions on achieving this ?

Regards,
Julia

#2 Julia-the-PCGP

Julia-the-PCGP
• Topic Starter

• Members
• 38 posts
• OFFLINE
•
• Gender:Female
• Location:Streatham Hill
• Local time:11:06 AM

Posted 21 May 2012 - 03:04 AM

Hi again,

I've managed to create a chart, but can't seem to get the chart legend to show the column I want which is the number 6, 12, 18, etc - it insists on showing the row numbers of 1, 2, 3 .....

I created an extra column and used the Countif formula to add up how many of each number set there was, basing the chart on this column alone to get the correct pie chart.

Can you help me with this specific problem ?

Regards,
Julia

#3 ReviverSoft

ReviverSoft

Happy to help!

• Members
• 1,552 posts
• OFFLINE
•
• Gender:Male
• Location:Somewhere on this planet...
• Local time:04:06 AM

Posted 21 May 2012 - 03:27 AM

Edit:

http://office.microsoft.com/en-us/excel-help/modify-chart-legend-entries-HP010007434.aspx

^ Maybe the "Changing Legend entries" bit will help.

Edited by ReviverSoft, 21 May 2012 - 03:50 AM.

ReviverSoft - Happy to help!

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users