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

"kate" wrote in message
...
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

"kate" wrote in message
...
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