I am completely fed up!!

K

kate

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
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Line Chart - Problems with labeling X-Axis 3
How do I get all 5 graph charts to show data (not be greyed out)? 1
Problem Printing Excel Graph -data doesn't show up when printed 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Multiple Line Graphs 5
surface chart 1
Constant % on X axis 2

Top