PivotTables' name? And the PivotChart

G

Gcook888

This could be the dumbest question of all time:

In Access I can right click on things and pick up Properties from the shortcut
menu. Most objects have a name property.

I have an Excel PivotTable and PivotChart on Sheet1. I have a PivotChart by
itself on ChartSheet Chart1.

The ObjectBrowser isn't too helpful (yet). I thought (from seeing Access way)
that Sheet1 would show as a member the PivotTable. But it doesn't.

I'd like to program VBA with the PivotChart and PivotTable but I don't even
know what to call them. HOW CAN I REFER TO THEM IN CODE?

They seem to be like the Charts made w/Microsoft Graph 2000 in Access. Are
they that?
 
T

Tom Ogilvy

msgbox Worksheets("Sheet1").PivotTables(1).Name

The name of the PivotChart is Chart1

Since it is on a separate chart sheet, the chart is the chartsheet.

Excel has its own graphing/charting component integral to Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can I get the worksheet with the pivottable sourcedata whenworking with a pivotchart ? 4
autoupdating a pivottable (but only when theres enough data to make the table) 2
PivotChart View Bugs!!! 7
Data labels on PivotCharts shown as Integers, I need 2 Decimal Pla 2
Change name of labels in a PivotChart 4
How can I get an access pivotchart into power point? 2
Pivot Chart: cannot apply the default chart type... 1
PivotTable and PivotCharts Problem - Manipulating in VBA 1

Top