Excel graph, don't show 0

  • Thread starter Thread starter flaviooooo
  • Start date Start date
F

flaviooooo

Hi,

I'm creating an excel scatter graph (excel 97) based on data in an
access table.

The data is as follows:
jan feb mar apr may ...
(Y Axis)Output 6000 5855 4881 0 5000
(X Axis) M2 55 58 61 0 50

I've created a range to define the source data:
=OFFSET(Main!$A$2;1;1;1;'Main'!$A$1)

A1 = the current month, so for example if a1 = 5, it'll take 5 columns
to the right (up until may)

Now, all this works fine except for the 0 values in april. These drop
my chart all the way out of the picture, and I'd like to simply exclude
these values.

Is it possible to do this in the range I defined? So just say: take all
values, except when they're 0?

Thanks in advanceHi,

I'm creating an excel scatter graph (excel 97) based on data in an
access table.

The data is as follows:
jan feb mar apr may ...
(Y Axis)Output 6000 5855 4881 0 5000
(X Axis) M2 55 58 61 0 50

I've created a range to define the source data:
=OFFSET(Main!$A$2;1;1;1;'Main'!$A$1)

A1 = the current month, so for example if a1 = 5, it'll take 5 columns
to the right (up until may)

Now, all this works fine except for the 0 values in april. These drop
my chart all the way out of the picture, and I'd like to simply exclude
these values.

Is it possible to do this in the range I defined? So just say: take all
values, except when they're 0?

Thanks in advance
 
flaviooooo
If the zeros in your table were #N/A then Excel will ignore them when graphing. You could use an IF statement or =NA() to have the NA error, and use a conditional format of a white font to hide the error diplay in your table

You might be able to set up an array entered IF function to do this in your source data function

Good Luck
Mark Graesse
(e-mail address removed)

----- flaviooooo > wrote: ----

Hi

I'm creating an excel scatter graph (excel 97) based on data in a
access table

The data is as follows
jan feb mar apr may ..
(Y Axis)Output 6000 5855 4881 0 500
(X Axis) M2 55 58 61 0 5

I've created a range to define the source data
=OFFSET(Main!$A$2;1;1;1;'Main'!$A$1

A1 = the current month, so for example if a1 = 5, it'll take 5 column
to the right (up until may

Now, all this works fine except for the 0 values in april. These dro
my chart all the way out of the picture, and I'd like to simply exclud
these values

Is it possible to do this in the range I defined? So just say: take al
values, except when they're 0

Thanks in advanceHi

I'm creating an excel scatter graph (excel 97) based on data in a
access table

The data is as follows
jan feb mar apr may ..
(Y Axis)Output 6000 5855 4881 0 500
(X Axis) M2 55 58 61 0 5

I've created a range to define the source data
=OFFSET(Main!$A$2;1;1;1;'Main'!$A$1

A1 = the current month, so for example if a1 = 5, it'll take 5 column
to the right (up until may

Now, all this works fine except for the 0 values in april. These dro
my chart all the way out of the picture, and I'd like to simply exclud
these values

Is it possible to do this in the range I defined? So just say: take al
values, except when they're 0

Thanks in advanc
 
Back
Top