L
Legacy 382715
Guest
Hej guys,
so I'm a bit stuck and could definitely need your help.
I want to create 1 Combo Chart which will change the shown data via a drop-down list. Fair enough, up to this point I really don't have a problem.
Still, I want to keep the charts dynamic, which I would do via OFFSET and Name manager.
Now, I would like that every time I change the name in the dropdown list, that it takes the information of 2 columns out of the name manager.
To make it clear I attached an image.
If the dropdown says "Total" I'd like that it shows the values of "Volume" & "Avg Intensity" in column "G" & "H".
If I then change the dropdown list to for example "Bench" it is supposed to take the values "Volume" & "Avg Intensity" in column "O" & "P"
As mentioned, I want to keep the charts dynamic and this is why I created Offset functions via the name manager.
Do you get the idea behind it?
Can anyone help out?
so I'm a bit stuck and could definitely need your help.
I want to create 1 Combo Chart which will change the shown data via a drop-down list. Fair enough, up to this point I really don't have a problem.
Still, I want to keep the charts dynamic, which I would do via OFFSET and Name manager.
Now, I would like that every time I change the name in the dropdown list, that it takes the information of 2 columns out of the name manager.
To make it clear I attached an image.
If the dropdown says "Total" I'd like that it shows the values of "Volume" & "Avg Intensity" in column "G" & "H".
If I then change the dropdown list to for example "Bench" it is supposed to take the values "Volume" & "Avg Intensity" in column "O" & "P"
As mentioned, I want to keep the charts dynamic and this is why I created Offset functions via the name manager.
Do you get the idea behind it?
Can anyone help out?