Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Charts
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 ? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Charts
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 ? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Charts
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 ? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Charts
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 ? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Charts
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 ? |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Charts
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 ? |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Charts
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to click on charts & unable to create any new charts Excel | Charts and Charting in Excel | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
Charts - How to have multiple charts share a legend. | Charts and Charting in Excel | |||
interactive charts for stacked bar charts | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel |