ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I suppress values from appearing in a graph? (https://www.excelbanter.com/excel-discussion-misc-queries/116316-how-do-i-suppress-values-appearing-graph.html)

Kim

How do I suppress values from appearing in a graph?
 
Hi there,

I've been doing a lot of graphs and want to suppress certain values
from appearing.

In the past, I make those values #N/A and this has worked fine. Now, I
find that my graphs sometimes show these #N/A's rather than suppressing
them.

Can anyone assist me? Basically, I need a way to suppress the values.
Using zero's or spaces is no good.

Any help much appreciated.

Kim



All times are GMT +1. The time now is 02:32 AM.

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