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

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" <(E-Mail Removed)> wrote in message
news:A46B0201-651A-46BA-ABA4-(E-Mail Removed)...
> 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
>

Jon,
I am avoiding the worksheet because I am trying to minimize its size, I have
a lot in them.
would it be possible to point to the same Y vector but somehow scale it and
present it along with the original?
Dan

"Jon Peltier" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:A46B0201-651A-46BA-ABA4-(E-Mail Removed)...
> > 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
> >
>
>
>

You mean minimize file size? It won't help. You can in fact use names to
plot data that doesn't appear in the sheet, but this does not affect file
size at all, and it makes it harder to make adjustments if the parameters
change, because you cannot see the formulas.

I always advise users to put formulas and values in the worksheet, so that
they can see any intermediate calculations. If there is any file size
savings, it is insignificant in terms of the cost of file storage and
especially in terms of the time it will take someone else to figure out what
you've done, or the time it will take you in two weeks to remember and
reconstruct what you've done.

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


"Daniel" <(E-Mail Removed)> wrote in message
news:E098FFF4-4D7E-4458-9BAB-(E-Mail Removed)...
> Jon,
> I am avoiding the worksheet because I am trying to minimize its size, I
> have
> a lot in them.
> would it be possible to point to the same Y vector but somehow scale it
> and
> present it along with the original?
> Dan
>
> "Jon Peltier" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:A46B0201-651A-46BA-ABA4-(E-Mail Removed)...
>> > 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
>> >
>>
>>
>>