+ Reply to Thread
Results 1 to 2 of 2

non linear 2nd axis for a graph

  1. #1
    Registered User
    Join Date
    01-17-2008
    Location
    canadaaaaa
    MS-Off Ver
    2019
    Posts
    55

    non linear 2nd axis for a graph

    hello, i would like to have a graph with 2 axis:

    one axis 0 to 100% (showing how the project is progressing).
    the other one i would like to see how many days we are late on the project BUT, i dont want to see another curve in the graph! in order to do this, the second axis woulnt count 0,1,2,3,4,5...X, it would show how late we are in relation to the %

    i would like to do this so the added curve doesnt confuse people that dont read graphs often

    am i dreaming or theres a way to do this?
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: non linear 2nd axis for a graph

    Instead of plotting percent complete, you could instead plot events as plan dates versus actual dates; if you're below the actual=plan line, you're behind schedule.
    Last edited by shg; 06-05-2014 at 11:14 AM.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Correlating x-axis data with two y-axes that are non-linear
    By utahmoose in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-24-2012, 07:59 AM
  2. How to make GRAPH with linear x axis
    By dcvrtila in forum Excel General
    Replies: 4
    Last Post: 01-25-2011, 07:31 AM
  3. Powerpoint Graph- Shading in between two linear graph lines
    By TerenYoung in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-15-2006, 04:35 AM
  4. [SOLVED] plotting 'random' data on a linear x-axis
    By tengel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-23-2006, 05:40 PM
  5. stock chart non-linear y-axis
    By Alseikhan in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-28-2006, 06:40 PM

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