Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

scale factor for individual chart series

scale factor for individual chart series

scale factor for individual chart series

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.

RE: scale factor for individual chart series

Aha!  Very simple and works like a charm.  I had fumbled around with it before and couldn't get it to work.  Thanks for showing the solution.

Eng-tips forums: The best place on the web for engineering discussions.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close