Is it possible for charts to use values on a report?

[JethroUK©]

I have a report that produces weekly statistics - it would obviously be nice
to include a graph ( i assumed that's why graphs are included in the
toolbox)

Is it possible for charts to use values on a report?

e.g. chart source data = these textboxes

I would imagine this is fundamental for 'report' graphs - but i can't see
anyway to do this (i'm happy to use VB if ness)

 

[Duane Hookom]

It is possible to add values to the datasheet of a graph however it is
sufficiently complex that you might want to try another method. Is there a
reason why you don't just set the Row Source to the appropriate SQL or a
saved query?

 

[JethroUK©]

i cant use a std row source (sql statement) since the report produces
statistics/analysis (not records) - each textbox (90+) is the product of a
different sql statement

shame - since graphs are ideal for producing stats

 

[Duane Hookom]

As I stated you can push value into the graph datasheet. I think "SA" has
posted some code for this in the past.

I don't even want to ask why all text boxes are the product of different SQL
statements.