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
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Dermot

Board Regular
Joined
Aug 11, 2006
Messages
199
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,983
Messages
5,834,709
Members
430,311
Latest member
JAC0617

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