×
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

Scatter overlayed on Polar

Scatter overlayed on Polar

Scatter overlayed on Polar

(OP)
I need some advice on how to execute the following graph.

Essentially I have a fixed point determined by location information (UTM East and UTM North, both in meters). I need to graph two concentric circles around that point at 50 and 65 meters around that point. I then need to overlay or insert a scatter chart several series of data points.

The point of all of this is to see how close vehicles come within a certain point using the 65m and 50m "rings" as points of interest.

I've attached something like what I am talking about. I created this in paint.

Thoughts comments?
 

RE: Scatter overlayed on Polar

(OP)
The vehicles locations are in the same metric (UTM coordinates) as the fixed point. Just FYI is anyone wondered.

RE: Scatter overlayed on Polar

The only challenging part is getting 1:1 aspect ratio for circles.  Do you need that or are ovals acceptable?

There are a few old threads on that subject.

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

RE: Scatter overlayed on Polar

As suggested, use an xy graph for everything.  Generate the circles from a series of straights and format to display lines only.  Plot the other points as marker only.

Look here for a couple of alternatives for scaling the graph so circles plot as circles, not ellipses.

http://newtonexcelbach.wordpress.com/2008/06/01/drawing-in-excel-1/

Doug Jenkins
Interactive Design Services
www.interactiveds.com.au
 

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