Chart question

  • Thread starter Thread starter Jesse
  • Start date Start date
J

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 - D6:D17

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?
 
=INDIRECT(Data!$F$25)
=INDIRECT("Data!$F$25")


try giving it a name and then use the name for your data source
 
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.
 
Back
Top