Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Data Scaling in same chart
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Data Scaling in same chart
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" 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Data Scaling in same chart
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" wrote in message ... 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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Chart Scaling | Charts and Charting in Excel | |||
Scaling within a chart | Charts and Charting in Excel | |||
Macro for Chart Scaling | Excel Programming | |||
value of chart scaling | Excel Programming | |||
Chart Scaling | Excel Programming |