Follow up question on updating secondary vertical axis

[Sheela]

Hello,

Thank you for your help on my previous thread where i had posted a question on updating the secondary vertical axis. I received replies to my question.

I used the instructions provided by Excel Ninja Luke on which I have a follow up question and I hope you will be able to help me.

Please refer to sheet "Data and Plot-A" in the attached excel file, where I tried to add the labels to the secondary vertical axis per your instructions. I was not able to add the text to the data labels. What should I be doing differently for this to work?
Thanks
Sheela

 

[Ashhu]

Dear Sheela,
With your attached document, I understand that you have created the desired label column ($O$) using concatenating data from K and L column.

Now to get Secondary VA label, please follow how you have in first tab i.e paste ='Data and Plot-A'!$O$5, ='Data and Plot-A'!$O$6 so on.....in the current label box. you need to double click on the box and enter the formula in top (Fx) radio button. See attached image.

Once you done that, next time when you change value in K and L cells, it update the label in chart. Hope i am clear.

-Ashwin

 

[Sheela]

Thank you for your help, I was able to insert the labels correctly.