Automatic Series Labeling?

ImbadatExcel

New Member
Joined
Jun 15, 2016
Messages
18
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!

1595527175308.png
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Dermot

Board Regular
Joined
Aug 11, 2006
Messages
85
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,319
Messages
5,595,465
Members
413,992
Latest member
CSEGUIN1973

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top