Automatic Series Labeling?

[ImbadatExcel]

Hello,

Any help with the following would be much appreciated!

I currently have a table with which I would like to crate a stacked area chart (see reference image). I would like the y-axis to be the raw data (values between 0-1 you see below), and I would like the x=axis to be the years you see in the table headers (2020 01, 2020 02, etc..).

My "help needed" is with regards to the series labels. Is there a method by which I can pull the series labels for their respective data sets without having to manually input each series label (under Column A, and also my grocery list)?

This table will also be growing, so if there is a method to "automate" this procedure that would be amazing.

Please let me know if my explanation was not clear. Thank you, again, in advance!

 

[Dermot]

If you want a chart that automatically expands to include new data, I suggest you format it as table (in the Home ribbon menu, look for Format as Table and use that).

Then create a chart using the whole table (it should automatically include the series labels).

When you add new rows, the chart will include them.