Chart with dynamic range - VBA

[pnjfksx]

I have some VBA that creates a set of data that can be up to 2 rows and 100 columns. Right now, it creates a chart that is always 100 wide, even when there is less data. How do I code something that dynamically sizes the chart based on the width of the data?

Thanks!

 

[Smitty]

See: http://www.beyondtechnology.com/geeks021.shtml for an excellent example.

Hope that helps,

Smitty