| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Combining Data on a pie chart
I have a data range that I am charting to show percentage of total of the
various data categories. The problem is there are a lot of categories under 2% I wish to combine into 1 entitled 'Misc' Does anyone know a way to combine several data points into one. TIA - Mark |
|
#2
|
|||
|
|||
|
Try selecting a Pie chart and choosing Pie of Pie or Bar of Pie.
"Mark C" wrote in message ... I have a data range that I am charting to show percentage of total of the various data categories. The problem is there are a lot of categories under 2% I wish to combine into 1 entitled 'Misc' Does anyone know a way to combine several data points into one. TIA - Mark |
|
#3
|
|||
|
|||
|
Barb,
Thanks, that combines the small percentage data but then shows those points as a subset pie or bar. I just want to combine them into one? Any further suggestions? Thanks - Mark "Barb Reinhardt" wrote: Try selecting a Pie chart and choosing Pie of Pie or Bar of Pie. "Mark C" wrote in message ... I have a data range that I am charting to show percentage of total of the various data categories. The problem is there are a lot of categories under 2% I wish to combine into 1 entitled 'Misc' Does anyone know a way to combine several data points into one. TIA - Mark |
|
#4
|
|||
|
|||
|
Mark -
It might be easiest of all to do a little math in the spreadsheet to add up these Misc slices, and plot the adjusted data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Mark C wrote: Barb, Thanks, that combines the small percentage data but then shows those points as a subset pie or bar. I just want to combine them into one? Any further suggestions? Thanks - Mark "Barb Reinhardt" wrote: Try selecting a Pie chart and choosing Pie of Pie or Bar of Pie. "Mark C" wrote in message ... I have a data range that I am charting to show percentage of total of the various data categories. The problem is there are a lot of categories under 2% I wish to combine into 1 entitled 'Misc' Does anyone know a way to combine several data points into one. TIA - Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| How many data points can you have in an Excel for a Scatter Chart. | Charts and Charting in Excel | |||
| Flip the X and Y data on a chart so that the Y data is vertical. | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
| Bar Chart for Text Data | Charts and Charting in Excel | |||
Linear Mode
