You can change all aspects of the chart in code.
Record a macro of the changes you would like, then adapt the values to suit
your size/scale.

NickHK

"nbaj2k" wrote in
message ...

I have a nice graph that I have at the end of my macro that is created.
The amount of records that are included vary, depending on the date
range picked in the beginning.

Is there code I can put in to automatically scale a graph? Sometimes
if some of the titles are longer or if there are a lot of entries it
will mash all of the titles together so you can't read them.

Is there anyway to fix this? I really want to show this spreadsheet
macro to the boss who I think will be very impressed. I'm using a bar
graph with horizontal bars and the labels on the left side.

I really hope there is a way,

Thanks!

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile:
http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=570906