×
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

PLOT SCALING

PLOT SCALING

PLOT SCALING

(OP)
here is the problem I have data like so (see below) in length and hight and I need to plot this data in a line chart where the Y-Axis is scaled to the X-Axis.  Such that if the X-Axis's scaled to 10meters per inch on paper that the Y-Axis's is scaled to 10meters per inch on paper.  Thus one can see the scaled (true) profile.

data in METERS
Length      Height
X - Axis    Y-Axis
200      678
195      679
190      680.1
185     681.2
180      682
175      683.1
170     684.9
165     686.1

RE: PLOT SCALING

I don't think that Excel can do this.

Any CAD package probably could.

RE: PLOT SCALING

Should be possible via macro's - adjust graph scales to match requirements. If interested can write one up - no built in function that I know of in chart menu.

RE: PLOT SCALING

One trick is to plot a second series on the same graph, but colour it invisible. The series should consist of two points,
minx,miny and maxx,maxy

I thin this will work, but have not tried it.

Cheers

Greg Locock

RE: PLOT SCALING

If you can live with a chart which is scaled equally in both x and y directions, but you may not know the scale, then try this:

1. Make the chart

2. Set the scales to have the same number of units between min and max, e.g the x-axis goes from 160 to 210 (50 m), and the y-axis goes from 650 to 200 (also 50m).

3. Write this macro in a VBA module:

Sub Macro1()
    ActiveChart.PlotArea.Select
    Selection.Width = 250
    Selection.Height = 250
    ActiveWindow.Visible = False
End Sub

4. Select the chart on the worksheet and run the macro.

This way you will see the true scaled profile.

To make the chart larger, change the number 250 in the macro to a larger number instead of dragging the chart.


If you want to make sure that the (on paper) plotted chart is scaled to exactly one inch per meter, then you need to figure out how points correspond to pixels and how pixels correspond to an inch on the printed paper. I'm not sure how the first is done but the second is shown in the page setup for your printer.


Hope this helps
regards
Mogens


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