How to change graph axis name automatically?

Hi,

I have created a graph with 2 axis'.
The one on the bottom axis says "Weeks"
The one on the side axis says "Kilograms"

I then created a drop down menu to change the kilograms to pounds (and it converts/changes the weight shown and bars ect) but on the graph it stays at "Kilograms" and i cant find a way to change it to pounds when pounds is selected or kilograms when kilograms is selected, automatically.

I tried to use a IF code

=IF(K10="Kilograms ","Kilograms","Pounds")

But i get the message " The function isn't valid"

So how do I do it?

Thanks for any help!

The easiest option would be the first chart in the attached example where the series name is controlled by E. Change the series within the chart data and the chart title updates.

The second option is simply a text box with a reference to E1.

Nice to know and thanks for the feedback.

Please don't forget to mark as solved...