Formulas and charts

[neilb]

I am having a friday afternoon nightmare at work.
I have created a spreadsheet which has a formula which searches another page for an account number and returns a relative figure. When trying to do a chart with these figures, the chart is reading these figures as zeros.

Is there a way to get around this?

Many thanks

Neil

 

[Mark W.]

On 2002-04-19 08:46, neilb wrote:
I am having a friday afternoon nightmare at work.
I have created a spreadsheet which has a formula which searches another page for an account number and returns a relative figure. When trying to do a chart with these figures, the chart is reading these figures as zeros.

Is there a way to get around this?

Many thanks

Neil

Care to provide some sample data? Are you sure that your numbers aren't really text values (i.e., "1" instead of 1)?