Updating secondary vertical axis

[Sheela]

Hello,
I have created a column chart. On the vertical secondary axis, I have manually drawn lines to define the category at: 25, 50, 75 and 100. Can the lines be updated automatically when I change the interval?
I drew a text box and entered text manually. Is there a way that the text entry can be automated from a table entry?

Thanks for all your help.
Sheela

 

[vletm]

Could You use real vertical secondary axis?
and
Instead of text boxes something like this simple solution?

 

[Luke M]

Hi Sheela,

Check out the attached. I created a dummy series to plot the lines. It uses x-error bars to create the blue lines. The other added series plots the labels at the mid points. To change things, edit any of the values in the orange cells.

 

[Sheela]

Thank you both for your prompt responses and effective solutions to my questions.
This is a great site for getting answers to top excel questions.