how can I show repeating values in a chart?

C

Cindy

I would like to show modes in the form of a pie chart but am not sure how.
For example the number 73 comes up 3 times in a column on my spreadsheet, how
can I show that compared to the number 50 which come up 2 times in the sheet?
Thanks for the help
 
A

Andy Pope

Hi,

You will need to compute those values using formula or a pivot table and
then chart the results.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Gantt chart duration not showing 0
Creating a Chart on form from selected data in query. 0
Move Chart with Text 0
making a chart complicated 1
How to Shop Client delays in my ghantt chart so i can claim for delays 0
Finding the proper style field and the numbered paragraph value within the style 0
One extra x axis item that wont go away - can anyone help? 3
excel charts 0

Top