Just wondering if there is a way to modify or change the RowSource property of the MS Graph object?
I have a report with a graph embedded in it but I can find a way to change the SQL query behind the graph. Anything I try doesn't work (i.e. like trying to set GraphObject.Application.DataSheet properties). I get errors like "object doesn't support that property or method" or others to that effect.
I can set the underlying query using a macro by changing the value of [Reports]![MainReport]![GraphObject].[RowSource] using SetValue, but how on earth do I do this using VBA? I would have thought that this would have been a handy feature to have so why isn't it easy to find (or maybe I'm just going blind)
any help in this matter would be great.