Automatically update Legend entries (Series) in a SCATTER X Y Chart

[pedrofilipegomes]

Hello,

I am creating a xy scatter (bubble) chart, which is fed by a data table and I wanted to be able to automatically update the "Legend Entries (Series)" chart whenever I add a new row to the table.

Can you help me?

I attach the document, with the table on the Sheet "Data% Opening" and the chart on Sheet "Chart1".

I've tried it through VBA, but to no avail.

Thank you .

[MrShorty]

If I may say so, a separate data series for each entry is not a convenient way to build this kind of chart. Here's how I think I would build it:

1) Create chart with a single data series extending from row 7 to row 107 (or whatever you will need).
2) Format the data series so that the fill color varies by point (format data series dialog).
3) Add data labels to the series or to a dummy series to identify the newsletter corresponding to each point/color.

I think that's how I would build this chart.

[pedrofilipegomes]

I did what you say and solved my problem...Thank you so much.