Hi All,
I have a series of parameters for which there is parameter values over
several years. I need to graph each parameter on a graph and put them into a
report. I also need to allow the user to select or un-select which
parameters need to be in the report. All the graphs will have the same
format, ie three pieces of data (one for each year), a Title, and X and Y
axis scale, and legends. I could hold this information on a separate table,
and would like to use it to create the graphs dynamically, generically. I
have no difficulty in generating the recordsources.
The report could be in access, or could be a word document.
Can anyone suggest an approach which might work best, and point me to any
resources / examples of creating graphs on the fly from data like the above.
Thanks in advance.
Gerry Abbott