legendentries

Is there a way to see when some legend items are not displayed? My dynamic chart has a legend with dynamic area size. So depending on amount of series and the legend are, some legend entries may not be shown (no space for them). I just want to add a warning to my user in such a case. I have...

Hello, I'm working with 3D Surface Charts using Personal Macro WB. The 3D chart is in a Chart Sheet and NOT embedded. I need to put the LegendEntry(12) text into a variable. I can Bold the text using ActiveChart.Legend.LegendEntries(12).Font.Bold = True But I can't figure out how to retrieve...

Good Afternoon All, I have a chart which at the moment has multiple duplicate series names. The series names are used to define the colour of the bar in a bar chart which ultimately makes a time schedule showing when different activities are going to be done. However, the legend contains all...

I made an excel template with some VBA behind to make a contour plot of some hardness data (x, y and hardness data provided in .csv file). The user can browse to the csv file with raw data, then data is processed and placed in a pivotTable. From this table a contour plot is made. In the main...

<tbody> I've been a few days trying to find the mistake or what I'm doing Wrong. I show here the current output and what it should be. I think maybe i'm defining the range with some mistake, or maybe <code>LegendEntries(i)</code>, doeasn't work with the same index as...