Changing a chart (OWC) not based on a array but on a pivot table 
Author Message
 Changing a chart (OWC) not based on a array but on a pivot table

Hi,

I have a data access page where i have a pivot table an a chart
now I want to change the chart from a pie to a clustered column chart an
backwards

I have the VBScript code but only when de data is an array:

           With oChart.SeriesCollection.Add
                .Caption = "1998"
                .SetData c.chDimCategories, c.chDataLiteral, _
                         Array("East","West","North","South")
                .SetData c.chDimValues, c.chDataLiteral, _
                         Array(1000, 2020, 1800, 1300)
           End With

So how can I change this script so the data would be from my pivot table
named pvtable1
instead of an array.

Thanks



Sun, 11 May 2003 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Binding Chart to Pivot table

2. Parameter Arrays; Pivot Tables

3. Problems with OWC.Chart and SetData

4. OWC Chart Help

5. read or changing the cell height and width of XML based table

6. Dynamic HML Tables based on # of NOT NULL columns in RS

7. urgent .. attach recordset to chart / pivot tble

8. Pivot tables - new to VBScripting

9. Pivot Table Help with VBScript

10. Pivot Table Active X Control (Office 2000)

11. Crosstab or pivot table with vbscript

12. Report based on Query file not reflecting changes:

 

 
Powered by phpBB® Forum Software