×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

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

Jobs

Scale limitations in Excel

Scale limitations in Excel

Scale limitations in Excel

(OP)
Much as I like excel, one thing that really bugs me is that I cannot have a scale for each column of data.
When dealing with multiple sets of data, using the primary and secondary axis is no help as I usually have to exclude some data then re-graph with the other sets.

The alternative is to that I don't see the detail... for example, when I log density in the range 850-870kg/m3 and temperature on the other axis at 35-50degC I can't display viscosity in the range 175 to 180cst.

Unless, off course, I set the scales from 0-870, in which case temperature appears to be a flat line...

Any solutions out there? (apart from including a scale multiplier to my data to bring all the data into the same range..)

Is there an alternative to Excel that will let me assign individual scales for each set of data?

JMW
www.ViscoAnalyser.com

RE: Scale limitations in Excel

Jon Peltier has a lot of good examples to work with charts and multiple axes - I won't repeat that here. Please visit his site at http://peltiertech.com/Excel/Charts/index.html

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

RE: Scale limitations in Excel

That has always bugged me, too.

I browsed the link above and think the specific portion applicable to the question is here:
http://peltiertech.com/Excel/Charts/TertiaryAxis.html

(still seems like more work than it needs to be!)

=====================================
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!


Resources