Adding a target line to two axes chart

[Jovin]

Hi,

I have created a two axes (line= yield (%) & bar= volume) chart & woul
like to add a target line (across y-axis) for targeted yield
Appreciate if anyone can help on this.

Thanks in advance

 

[Andy Pope]

Hi Jovin,

You can find so details on adding target lines here

http://peltiertech.com/Excel/Charts/ComboCharts.html#AddLine
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

 

[Jovin]

Hi Andy,

Thanks alot for your kind help.
The only problem is I am trying to add a target line on a two axes (
different y-axes) chart. Pls refer to attached excel.

Thanks so much.

Jovin

 

[Andy Pope]

Hi,

Please, no attachments in the NG.

You can email the file to me directly.

Cheers
Andy

 

[Jon Peltier]

Jovin -

Doesn't this mean you need two target lines?

Are you trying to line up the target lines so you only need one for two
axes? You need to tweak the scale parameters for the two coordinate
systems, so the target appears at the same fraction of the distance from
the minimum to the maximum.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Jovin]

Hi Jon,

Andy has already helped me resolved the problem thru' email.

Andy: Thanks a million!

Thank you all for your time.

Cheers,
Jovin