Chart axis uses N/A

[chasethewind]

I have a chart that is using the N/A values for the axis labels. It is labeling the N/A value as zero. How can I format the chart so it does not use the N/A value?

 

[SkipVought]

Hi,

If you have N/A values VISIBLE, they will show on the x-axis.

Use the AutoFilter to make those rows hidden.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlhelp]

You can't get away form the #N/A Label.

One thing to do is convert #N/A's to a Zeros using whatever formula you need to.

Then, Custom format your data list as something similar to:

#,##0_);(#,##0);

where formatting before the first semi-colon represents a positive number; between the two semi-colons represents a negative number; and the last semi-colon (second, actually) without any formatting info will hide the zeros. And the Zero labels will not show up in your chart.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents