electricpete
Electrical
- May 4, 2001
- 16,774
Is there a way to apply an individual scaling factor to each series in a chart, without actually creating a new scaled set of data?
For example, I am repeatedly run a model which produces 5 output variables vs time (trying different input parameters and looking at effect on output waveforms). The 5 output variables for a given run might have ranges 0-0.001, 0 – 1, 0-100 etc and don't plot very well on the same chart, so I'd like to be able to adjust a scale factor for each one to make them fit together on the same chart well. I don't know what the scale factor is ahead of time.
I could certainly do it by creating a new column for each set of output data with formula scale factor times original data (that's probably what I'll end up doing).
But it clutters up my worksheet (which is already very large and cluttered), and isn't particularly elegant. I remember the "ChartFrmla" spreadsheet had clever ways to use named formula's in charts to avoid having to put extra data into cells. Can we create a named formula multiplier1*range1 and plug it into our chart series without creating an extra copy (scaled) of range1 ?
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
For example, I am repeatedly run a model which produces 5 output variables vs time (trying different input parameters and looking at effect on output waveforms). The 5 output variables for a given run might have ranges 0-0.001, 0 – 1, 0-100 etc and don't plot very well on the same chart, so I'd like to be able to adjust a scale factor for each one to make them fit together on the same chart well. I don't know what the scale factor is ahead of time.
I could certainly do it by creating a new column for each set of output data with formula scale factor times original data (that's probably what I'll end up doing).
But it clutters up my worksheet (which is already very large and cluttered), and isn't particularly elegant. I remember the "ChartFrmla" spreadsheet had clever ways to use named formula's in charts to avoid having to put extra data into cells. Can we create a named formula multiplier1*range1 and plug it into our chart series without creating an extra copy (scaled) of range1 ?
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
