+ Reply to Thread
Results 1 to 3 of 3

Charting Data to have intersection at top left

  1. #1
    Registered User
    Join Date
    02-01-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    44

    Charting Data to have intersection at top left

    hi there,



    I'm trying to chart some data.



    Specifically:



    Depth Calcium
    10 0.6
    60 0.6
    90 0.8




    I wish to have the calcium details as my x-axis, and the depth column to be the y-axis. I also wish to have the graph to intersect at the top-left of the chart (with 0 at the top-left). Basically it will look like a reverse L, and the line to drop straight down from 0.6 and then to bend to touch 0.8. Is there a way I can generate this please?



    Thanks in advance.

  2. #2
    Registered User
    Join Date
    01-16-2012
    Location
    Wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Charting Data to have intersection at top left

    Open the Y-axis "Format Axis" menu, go to the "Scale" tab and check the "Values in reverse order" option. I think that will do what you are looking for.

  3. #3
    Registered User
    Join Date
    02-01-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: Charting Data to have intersection at top left

    Thanks a lot, worked as per what I needed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1