×
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

Rescaling Chart Axes

Rescaling Chart Axes

Rescaling Chart Axes

(OP)
I need to set up charts which "read" results to use as the X axis and automatically draw the axis to a linear scale, regardless of the values.  (Quattro does it but I can't find a route in Excel)
I am attaching a spreadsheet as a sample.  Similarly how can I reset the linear axis so that it becomes logarithmic?

Should be simple I know but the only way I can make it work is by manipulating formulae to create evenly spaced values in the results.

David

RE: Rescaling Chart Axes

You have used a "line" chart.  You need to change it to the "scatter (X/Y)" type.  Right click on the chart, and select "change chart type".

To change either scale to logarithmic, right click just below the axis and select "format axis", then click the "logarithmic scale" box.

You will need to change the first chart point to something greater than zero.

The instructions above are for 2007/2010.  The procedure may be slightly different for earlier versions.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
 

RE: Rescaling Chart Axes

That pretty much sums it up. Except in Excel 2000 and I think 2003, you can't change a chart type (by right-clicking) once it's created... you have to create a new chart of the new type.

=====================================
(2B)+(2B)'  ?

RE: Rescaling Chart Axes

my mistake. Thanks

=====================================
(2B)+(2B)'  ?

RE: Rescaling Chart Axes

(OP)
Thanks !!  I totally missed that !!
David

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