I am completely fed up!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top