I'd like to have a pivotchart which is the line on 2 axes type, but every
time I change something in the pivotchart, it changes back to its default.
Is there some code that I can have which works on any refresh/change of the
chart, which would automatically make the chart type go back to line on 2
axes?

Thanks.
--
Boris

You could record the steps as you manually apply the chart type.
Then, add that code to the Worksheet_PivotTableUpdate event.

BorisS wrote:
I'd like to have a pivotchart which is the line on 2 axes type, but every
time I change something in the pivotchart, it changes back to its default.
Is there some code that I can have which works on any refresh/change of the
chart, which would automatically make the chart type go back to line on 2
axes?

Thanks.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Got the basic code. What is the worksheet_pivotableupdate event, or how do I
invoke it?

Thx.
--
Boris


"Debra Dalgleish" wrote:

You could record the steps as you manually apply the chart type.
Then, add that code to the Worksheet_PivotTableUpdate event.

BorisS wrote:
I'd like to have a pivotchart which is the line on 2 axes type, but every
time I change something in the pivotchart, it changes back to its default.
Is there some code that I can have which works on any refresh/change of the
chart, which would automatically make the chart type go back to line on 2
axes?

Thanks.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

It's a worksheet event in Excel 2002 and Excel 2003.

Right-click the sheet tab on the pivot table worksheet, and choose View
Code.
From the dropdown list at the top left of the code module, choose
Worksheet.
From the dropdown list at the top right of the code module, choose
PivotTableUpdate.
Add your code to this event.

BorisS wrote:
Got the basic code. What is the worksheet_pivotableupdate event, or how do I
invoke it?

Thx.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

This is specifically for a pivotchart, for which I did find the worksheet,
and for which I found the "chart_calculate" function. Unfortunately when I
put my macro in there to update the type and color of line, and I change the
value of the chart (select a diferent page field), it seems to go in a loop
of the macro. My guess is because the change of the chart happens, it
triggers the macro, because the macro changes something (although doesn'
actually calculate, just changes colors), the macro triggers, and so on.

Thx for any further help.
--
Boris


"Debra Dalgleish" wrote:

It's a worksheet event in Excel 2002 and Excel 2003.

Right-click the sheet tab on the pivot table worksheet, and choose View
Code.
From the dropdown list at the top left of the code module, choose
Worksheet.
From the dropdown list at the top right of the code module, choose
PivotTableUpdate.
Add your code to this event.

BorisS wrote:
Got the basic code. What is the worksheet_pivotableupdate event, or how do I
invoke it?

Thx.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

You could disable events at the start of the code, and enable them at
the end:

Application.EnableEvents = False
'your code
Application.EnableEvents = True


BorisS wrote:
This is specifically for a pivotchart, for which I did find the worksheet,
and for which I found the "chart_calculate" function. Unfortunately when I
put my macro in there to update the type and color of line, and I change the
value of the chart (select a diferent page field), it seems to go in a loop
of the macro. My guess is because the change of the chart happens, it
triggers the macro, because the macro changes something (although doesn'
actually calculate, just changes colors), the macro triggers, and so on.

Thx for any further help.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html