2 axes pivotchart when pivotitems is changed<[email protected]>

K

KEMAL EKMEN

u must record new one macro using the 2 axes graph that can be changed depending on your selection of currentpage. u can also use a combobox form and a new sheet containing graph already. when u change to the new pivotfield item pivotchart jump into your recorded macro. (when u change to the combobox item you can get data needed for graph )

'for finding items and get it written a new temp. file
Sub Node_selection_graph()

'To determine how many BSC Nodes are available in the data
reportfile = ActiveWorkbook.Name
Workbooks.Add
temp_file = ActiveWorkbook.Name
Windows(reportfile).Activate
Dim pt As PivotTable
Set pt = ActiveChart.PivotLayout.PivotTable
For i = 1 To pt.PivotFields("BSC").PivotItems.Count
'pt.PivotFields("BSC").CurrentPage = pt.PivotFields(" BSC").PivotItems(i).Name
Nodes(i) = pt.PivotFields("BSC").PivotItems(i).Name
Windows(temp_file).Activate
Cells(i, 1) = Nodes(i)
pt.ManualUpdate = False
pt.ManualUpdate = True
Windows(reportfile).Activate
Next i


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 

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

Change report firlds in pivot tables and charts with one selection 0
PivotItems.Count is 0 when items are visible on the sheet 4

Top