Have a macro resize the chart legend

[Gara]

What I need to do is have the height and width of my legend change based on the number of series and the length of the series names. Picking that information up isn't my problem (the LEN formula isn't exactly a mystery and I already make use of some code to pick up the series count).

What I'm not sure of is how to translate that into values for height and length. Once I have that I've already used the recorder to get the code to change height and width.

An example of the workbook is attached. The names used for the series are made up, but it doesn't matter, the names of the series will not be the same each time I update this workbook. A series could be there one month and not for the next several. Example sheet.xlsm

[Andy Pope]

Try removing the legend before processing a chart and then reapply it afterwards.

Please Login or Register  to view this content.

[Gara]

Looks like that got it. Thanks!