Automating Charts in Excel

[Richard Kerr]

Hello,

I have a procedure which runs from Access and creates a
series of sheets and Pivot Tables in Excel. I am trying to
automate the production of PivotCharts from the
PivotTables but the command I'm using seems to only
produce a chart from the sheet and not the content of the
pivot table.

I am using the following code to produce the chart.


code:
-----------------------------------------------------------
---------------------

'Create bar chart from the pivot tableDim chTop5Calls As
ChartObjectSet chTop5Calls = Worksheets(3).ChartObjects.Add
(100, 30, 400, 250)chTop5Calls.Chart.ChartWizard
Source:=Worksheets(3).Range("a3:h20")

-----------------------------------------------------------
---------------------

If anyone call point me in the direction of a different
command or use of this one it would be very much
appreciated

Thanks

Richard

 

[Phobos]

You might want to try one of the Excel groups...

P



<snip>