| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Controling how zero values are plotted in charts
Can anybody advise me how to overcome the following:
I am trying to create a chart whereby the source data is calculated from a formula. I do not want zero values to be plotted in the chart. I have tried the following, going to TOOLS, OPTIONS, CHARTS & then selecting 'plot empty cells as' = Not Plotted(leave gaps), but this does not overcome the problem. This function only seems to work when data is not related to a formula? I would be very grateful for any help that anybody can give Kind Regards Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| Zero Values on Charts | Charts and Charting in Excel | |||
| Negative or zero values cannot be plotted correctly on log charts | Charts and Charting in Excel | |||
| How do I hide 0 values in line charts | Charts and Charting in Excel | |||
| To get a lot of charts that contain different values in a minute | Charts and Charting in Excel | |||
Threaded Mode
