Avoid 0 values in a graph?

daru

Guest

Posts: n/a

22nd May 2006

Hi everyone,

i have a graph based on a pivot table with countries and production as
fields. What i need is the graph not taking into account the countries
with production=0% so those countries would not appear in it.

Any help would be greatly apreciated.

Thanks!

--
daru
------------------------------------------------------------------------
daru's Profile: http://www.excelforum.com/member.php...o&userid=34656
View this thread: http://www.excelforum.com/showthread...hreadid=544228

« cost benefit analysis and/or ROI templates | How to create org chart from excel file with reports to column »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Graph Negative Values as Positive Values	cringer	Microsoft Excel Charting	0	25th Apr 2010 08:31 PM
Avoid Null Values	Samuel Shulman	Microsoft Access	2	5th Nov 2006 02:52 PM
SUM(IF( Array to avoid #NUM! values	Elijah	Microsoft Excel Worksheet Functions	7	21st Nov 2004 02:17 PM
Graph - comparing values of 2 series while adding an attribute for each compared values	Chen G	Microsoft Excel Charting	2	1st Nov 2004 07:08 PM
Graph - comparing values of 2 series while adding an attribute for each compared values	Chen G	Microsoft Excel Misc	1	1st Nov 2004 02:44 AM