ExcelBanter - Excel Charts

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Excel Charts (https://www.excelbanter.com/charts-charting-excel/220817-excel-charts.html)

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 ?

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 ?

Hi Shane,

Here is the model of the data range:

Date 1 2 3 4 5 6 7 8

Sales 10 20 15 0 16 25 0 0

"Shane Devenshire" wrote:

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 ?

Put NA() in place of the zero values.
--
David Biddulph

"Raiju" wrote in message
...
Hi Shane,

Here is the model of the data range:

Date 1 2 3 4 5 6 7 8

Sales 10 20 15 0 16 25 0 0

"Shane Devenshire" wrote:

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 ?

Hi David,

I am sorry, it is not working.

"David Biddulph" wrote:

Put NA() in place of the zero values.
--
David Biddulph

"Raiju" wrote in message
...
Hi Shane,

Here is the model of the data range:

Date 1 2 3 4 5 6 7 8

Sales 10 20 15 0 16 25 0 0

"Shane Devenshire" wrote:

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 ?

I'm sure that the members of the group will consider your description of the
problem, with all the detail which you have provided. :-(
--
David Biddulph

"Raiju" wrote in message
...
Hi David,

I am sorry, it is not working.

"David Biddulph" wrote:

Put NA() in place of the zero values.
--
David Biddulph

"Raiju" wrote in message
...
Hi Shane,

Here is the model of the data range:

Date 1 2 3 4 5 6 7 8

Sales 10 20 15 0 16 25 0 0

"Shane Devenshire" wrote:

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 ?

I was surprised you even tried.

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
I'm sure that the members of the group will consider your description of
the problem, with all the detail which you have provided. :-(
--
David Biddulph

"Raiju" wrote in message
...
Hi David,

I am sorry, it is not working.

"David Biddulph" wrote:

Put NA() in place of the zero values.
--
David Biddulph

"Raiju" wrote in message
...
Hi Shane,

Here is the model of the data range:

Date 1 2 3 4 5 6 7 8

Sales 10 20 15 0 16 25 0 0

"Shane Devenshire" wrote:

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 ?