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!
Thanks!