Adding a target line to two axes chart

  • Thread starter Thread starter Jovin
  • Start date Start date
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
 
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
 
Hi,

Please, no attachments in the NG.

You can email the file to me directly.

Cheers
Andy
 
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/
_______
 
Hi Jon,

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

Andy: Thanks a million!

Thank you all for your time.

Cheers,
Jovin
 
Back
Top