ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I avoid that zero values in the data set are displayed in. (https://www.excelbanter.com/charts-charting-excel/138970-how-can-i-avoid-zero-values-data-set-displayed.html)

Stef

How can I avoid that zero values in the data set are displayed in.
 


David Biddulph[_2_]

How can I avoid that zero values in the data set are displayed in.
 
[Please ask your question in the body of the message, not just in the
subject line.]

Tools/ Options chart gives you various options for empty cells, but if your
cells aren't actually empty but contain zeroes (or "" which counts as zero)
then you may want to replace the zeroes by =NA()
--
David Biddulph

"stef" wrote in message
...





All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com