Adding a target line to two axes chart

J

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
 
J

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
 
A

Andy Pope

Hi,

Please, no attachments in the NG.

You can email the file to me directly.

Cheers
Andy
 
J

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/
_______
 
J

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
 
Top