Excel Charts

R

Raiju

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 ?
 
S

Shane Devenshire

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?
 
R

Raiju

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
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminating categories of zero values from X-axix 0
Excel 2007 charts: want to avoid zero values 1
One extra x axis item that wont go away - can anyone help? 3
Gantt chart duration not showing 0
simple chart 0
Finding asymptote equation and how to draw them in excel 0
Adding a line to a population bar chart 0
Scatter chart with categories on x-Axis 2

Top