Macro to create Chart (& layout)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

___________________________________________________________________
 
Back
Top