plotting longitude points

Posted on 2012-08-25
Last Modified: 2012-08-25
in excel how do i plot both west and east longitudes on the same x axis using excel 2010
Question by:holzjack
    LVL 43

    Expert Comment

    by:Saqib Husain, Syed
    You can plot the West longitudes as negative numbers and East longitudes as positive numbers. Or are you looking for something else?

    Author Comment

    Tried that but it puts the vertical axis at the 0 point on the x axis and i need the vertical axis to locate at the 150 E longitude with data points running up through 70 W.
    LVL 81

    Accepted Solution

    Right-click the x axis and select "Format Axis". Set Axis Value to -150.


    Author Comment

    That looks like it will work.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    This article will show you how to use shortcut menus in the Access run-time environment.
    No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now