Graphs: how to stop displaying a value

thorgal67 · #1 12-17-2010, 07:59 AM

Thanks Bjorn,

I had to edit the formula a bit since the Swedish version is a bit different from the Belgian one that we use.

In our Belgian version the correct formula is If(C3=0;#N/A;C3*D3)

Furthermore, although the line will no longer be visible in the graph, there will still be an ugly "#N/A" visible in my data. This I remove by using a Conditional formatting : Formula is =ISERROR(B2) and say that the format to use is a white background. That way the white background will hide the data.

Thanks again for your help

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linking of graphs to word - no color when printing	Sindre	Word	0	10-05-2010 04:45 AM
Embedded Excel Graphs - Custom Formatting	Cody	Drawing and Graphics	0	07-02-2010 02:30 PM
Linking graphs from excel	Markc	PowerPoint	2	05-11-2010 02:17 AM
Linked graphs printing wrong color	StaffsLebowski	Word	0	12-15-2009 08:44 AM
help to convert swf to avi for displaying in ppt?	Frederick	PowerPoint	1	09-13-2009 08:10 PM