Hi,
I am using VBA code to create an XYScatter chart using data. As we know that the Legend Key size is too small and cannot be resized and takes the max size of the Legend font, I want to replace each legend Key with a randomly colored circle (drawing toolbar) showing the X, Y values in the center. I am already replacing the data markers on the chart with randomly colored circles, with their centers showing the x,y values.
My question is, How do i find the Legend Key position and paste the appropriate circle containing the appropriate x,y values for that legend?
I am using VBA code to create an XYScatter chart using data. As we know that the Legend Key size is too small and cannot be resized and takes the max size of the Legend font, I want to replace each legend Key with a randomly colored circle (drawing toolbar) showing the X, Y values in the center. I am already replacing the data markers on the chart with randomly colored circles, with their centers showing the x,y values.
My question is, How do i find the Legend Key position and paste the appropriate circle containing the appropriate x,y values for that legend?