yeh! Wow wow... it works...But now I have another problem of fixing the value
of my 2nd Y axis from 0 to 100%, but everytime I change the choice, it
changes accordingly based on the logarithmic method. Please ... after this...
I am really done with my project. Any thought?

Woowww woooow ... You really make my day!



"Debra Dalgleish" wrote:

> If you put the code in the Chart_Calculate event, it should work.
>
> Rav99 wrote:
> > OK... I tried.. but it doesn't work... What I did ... I open VBE and click on
> > the Chart, on my right, I have Chart_Activate(), so I put the script you
> > provided underneath it and saved... but it doesn't work.
> >
> > Did I do something wrong?
> >
> > "Rav99" wrote:
> >
> >
> >>I created a Pivot chart from Pivot table, however, as the user changes the
> >>options (from pivot fields), then the chart type changes back to default one
> >>(I want the line-column 2 axes one). I figured I could go to VBA properties
> >>to default the chart type by choosing the chart code, however under that
> >>list, there is no chart code for that combination chart (line chart + column
> >>chart with 2 axes). How can I do this?
> >>
> >>Can someone help... as I am not good at VBA? Thanks!
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>