Please show us a sample of the data layout.

In general if you don't want to plot something that is within the plot range
you would either hide its rows or columns and the default behavior of a chart
is to plot only visible cells. So in your case it sound like you might want
to hide the columns of data that you don't want to plot. Or you may be
asking something else?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Raiju" wrote:

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 ?