Macro to create Chart (& layout)

[JS1]

Via a macro, (View)PivotChart, (DateMode)Read, is there a way to determine
how data elements will be placed automatically (rather than manually by
dragging from the 'Chart Field List' to the chart. I'm creating the same 30
charts every week, so would like to automate as much as possible.

Thanks

 

[JS1]

Hi, I was able to achieve the following.

However, what happens now is that when I refresh my tables, the macro does
not retain the settings (formatting, chart title, data elements).

What I want is to run Querys based on newer tables.
Run a macro to work on the new poutput, produce charts that have consistent
formatting/titles/layout etc.

I'm a novice to Access, so detailed help is really appreciated. Thanks

___________________________________________________________________