Thank you both for replying!!

This helps a lot!!!

I do have the 160 charts on 3 sheets in the same workbook. I started
researching MVP web sites as to how to automate and make them dynamic a
few weeks ago. I am off work for a couple of weeks due to a surgery and
figured this would give me plenty of time to try things. I had a
problem figuring out the syntax without going through the select and
activate business.

My plan was to loop through all of the charts in each individual
worksheet, setting variables (range adresses) according to the name of
the chart in the loop at the time using a select case structure. I
suppose I could even wrap all of this in a loop through the sheets as
well.

I intentionally left cMin and cMax as true variables as my category
axis is formatted as dates and the value axis is numerical in all
cases.

No matter what I end up with, it will still be better than having to
manually select and change each chart without VBA.


--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=568668