I would like to copy and paste the chart axis within my worksheet so that the
comparable graphs I have all show the same range if not they look stupid one
may show upto 70 and the other 30 which proves to be no good at all. The data
will change with the pivot refreshing so I need some kind of macro to keep
them all looking the same on one worksheet .I dont wnat to change numerous
graphs every time.

How do i do this ?????

Thankyou

How about a nice defined name for the range and then use
source=yourworkbook.xls!yourdefinedname

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"kate" <(E-Mail Removed)> wrote in message
news:358E0E3F-2E4F-4F4A-BDD9-(E-Mail Removed)...
>I would like to copy and paste the chart axis within my worksheet so that
>the
> comparable graphs I have all show the same range if not they look stupid
> one
> may show upto 70 and the other 30 which proves to be no good at all. The
> data
> will change with the pivot refreshing so I need some kind of macro to keep
> them all looking the same on one worksheet .I dont wnat to change numerous
> graphs every time.
>
> How do i do this ?????
>
> Thankyou

thankyou i shall try this

"Don Guillett" wrote:

> How about a nice defined name for the range and then use
> source=yourworkbook.xls!yourdefinedname
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "kate" <(E-Mail Removed)> wrote in message
> news:358E0E3F-2E4F-4F4A-BDD9-(E-Mail Removed)...
> >I would like to copy and paste the chart axis within my worksheet so that
> >the
> > comparable graphs I have all show the same range if not they look stupid
> > one
> > may show upto 70 and the other 30 which proves to be no good at all. The
> > data
> > will change with the pivot refreshing so I need some kind of macro to keep
> > them all looking the same on one worksheet .I dont wnat to change numerous
> > graphs every time.
> >
> > How do i do this ?????
> >
> > Thankyou
>
>