OK so the title is probably a bit rubbish.
I have data in Bell B2 and C2
B2 = 2023
C2 = 2022
Now and again I change these so the chart I have changes to reflect each year.
The Chart isn't a problem but I want the legends to read the data in above cells.
Blue series = what is in B2
Red series - what is in C2
Is that possible ?
Thanks in advance,
Bookmarks