If the data is listed in a column, filter the data using the autofilter or
by making the range into a list (Excel 2003) or a table (2007). The filter
hides certain rows, so filter out the zeros. Hidden cells do not appear in
charts by default (this can be changed if necessary), so filtering the sheet
also filters the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Raiju" wrote in message
...
Hi , I have a range of sales data from 1 - 30 of a month, i will select
the
all range while creating chart.What i want when click on the chart it
could
eliminate the zero value items from the X-axis. Could i have your help on
this ?