| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can I show repeating values in a chart?
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how can I show repeating values in a chart?
Hi,
You will need to compute those values using formula or a pivot table and then chart the results. Cheers Andy Cindy wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line Chart - show percent and value? | Charts and Charting in Excel | |||
| Only chart certain values | Charts and Charting in Excel | |||
| How do I show the Grand Total on a Pivot Chart? | Charts and Charting in Excel | |||
| How to assign character (text) values to y-axis in a Excel chart? | Charts and Charting in Excel | |||
| Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel | |||
Linear Mode
