Chart question

[Jesse]

I need to set a data range for a chart to:

=INDIRECT(Data!$F$25)

The value of the cell F25 in sheet 'Data' is - D617

My bar chart give me an error when I try to say ok.

Error is:
"Reference is not valid."

Are you not allowed to use functions in the 'Data range' field?

 

[Don Guillett]

=INDIRECT(Data!$F$25)
=INDIRECT("Data!$F$25")


try giving it a name and then use the name for your data source

 

[Jesse]

I gave it a shot but still got the same error. It's almost like functions
are not permitted in the Data range field. Just doesn't seem right.