Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-15-2010, 12:06 PM
BjornS BjornS is offline Graphs: how to stop displaying a value Windows Vista Graphs: how to stop displaying a value Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
here is a solution:

Assume the cells used for the chart has the following formula:
= C3*D3

Then change this into =if(C3=0,NA(),;C3*D3)

This will cause a "missing"-sign in the december cell, and the graph will not show this value at all.

I hope I got it right above with translation of commands from my Swedish Excel version into English.

Kind regards
Bjorn
Reply With Quote
Reply

Tags
graphics



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
Graphs: how to stop displaying a value 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
Graphs: how to stop displaying a value help to convert swf to avi for displaying in ppt? Frederick PowerPoint 1 09-13-2009 08:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft