I have a project containing numerous embedded charts across several worksheets. From time to time, I have seen that the legend font is being changed to a very small and unreadable font size (e.g. 3.4 pt instead of the 8 or 10 that I chose originally) without any obvious intervention on my part, though I suspect it might relate to very long entries from time to time. I finally decided to try to fix this problem by putting in some code to forcibly reset the legend font every time I enter new data into the worksheet, using the following syntax:
Worksheets("Sheet1").ChartObjects("Chart 1").Chart.Legend.Font.Size = 8
This code works perfectly for many of my embedded charts, but doesn't work at all for others. Given that all the charts that it works for are fairly new additions, I have a suspicion that it might have something to do with the age of a specific chart, as this is a project developed over many years, originally starting in Excel 2003. If so, does anyone know of a good way to "update" a chart without remaking it from scratch.
Worksheets("Sheet1").ChartObjects("Chart 1").Chart.Legend.Font.Size = 8
This code works perfectly for many of my embedded charts, but doesn't work at all for others. Given that all the charts that it works for are fairly new additions, I have a suspicion that it might have something to do with the age of a specific chart, as this is a project developed over many years, originally starting in Excel 2003. If so, does anyone know of a good way to "update" a chart without remaking it from scratch.