View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Add Data Scaling in same chart

Why must you avoid making the calculation in the worksheet? Worksheets are
made for calculations, and charts for displaying numbers. Charts cannot do
this kind of calculation.

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


"Daniel" wrote in message
...
Hello,
I am presenting in a chart Y vs X (curve #1).
I would like to add a second curve where Y is scaled by a factor: INT,
this
means the second curve is Y2 vs X where Y2=Y*INT.

I would like to do this WITHOUT the need to generate another vector Y2 in
a
workbook.

Is it possible?
Thanks