I have created a chart on a report that is attached to a simple access table with 4 columns. It displays fine. However, I need to change the charts .rowsource property to point to a new table. The new table will have the exact same structure as the old table (essentially a copy of the original table), just a new name and data. I have seen numerous posts about people changing the rowsource property at runtime in the reports VBA events, which I have done sucessfully but I still have an issue.
My issue is if I change the rowsource, even in the designer without messing with VBA code, the formatting I made to the original chart defaults. The formatiing tab where I set my checkboxes for the various settings such as the legend and axis default to unchecked; I have to reformat the report every time I change the rowsource, even if it exactly matches the same table data structure. I have seen numerous posts about changing the rowsource on the fly but I can't see how that would work since it appears to default all the format settings of the chart. Is there a way to stop this from happening?
Thanks for your time..