Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTables' name? And the PivotChart
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTables' name? And the PivotChart
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. -- Regards, Tom Ogilvy Gcook888 wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicating PivotChart / Changing PivotChart data range | Charts and Charting in Excel | |||
Multiple PivotTables | Excel Discussion (Misc queries) | |||
PivotTables | Excel Discussion (Misc queries) | |||
PivotTables | Excel Discussion (Misc queries) | |||
New to Pivottables- need help | Charts and Charting in Excel |