| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Charts
Hi
I have to columns of data, one with product types and the other with the amount which have been sold during the month. I would like to show this data as a pie chart however if I have not sold one of a product it still appears in the pie chart. How do I stop products with zero appeaing in the pie chart? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Charts
Hi,
before inserting the chart, sort the sold column, uncheck what shows as blank then insert the chart "Dave" wrote: Hi I have to columns of data, one with product types and the other with the amount which have been sold during the month. I would like to show this data as a pie chart however if I have not sold one of a product it still appears in the pie chart. How do I stop products with zero appeaing in the pie chart? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to click on charts & unable to create any new charts Excel | Charts and Charting in Excel | |||
| link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
| Charts - How to have multiple charts share a legend. | Charts and Charting in Excel | |||
| interactive charts for stacked bar charts | Charts and Charting in Excel | |||
| Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
Linear Mode
