+ Reply to Thread
Results 1 to 2 of 2

Timeline with accumulative no of days as Horizontal Axis

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Timeline with accumulative no of days as Horizontal Axis

    Hi, i have a column with number of days needed for each process and another column for the accumulative number of days.

    For presentation purposes, i wan to make a chart to show the timeline. HOwever, i cant seems to make it work. I tried using Line With Marker. HOwever, the line would go up n down instead of 1 straight line.

    Anyone can advice? Refer attached. I have aso manual draw out the chart i wan in the excel.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Timeline with accumulative no of days as Horizontal Axis

    I cannot see what you have tried, but your hand drawn chart looks like an XY scatter chart to me:

    1) I need a "vertical" position dummy value for the chart, so I enter 0 into D2:D6.
    2) Select C2:D6 -> Insert chart -> Scatter chart (with markers. with or without line as you prefer).
    3) Format the chart as desired.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. [SOLVED] create x-axis and a y-axis chart as an image horizontal and vertical values
    By Khaldon in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 10-11-2018, 09:12 AM
  2. Replies: 2
    Last Post: 04-15-2015, 01:10 AM
  3. Help with Axis on a Timeline
    By Chris_PLP in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-28-2014, 07:20 PM
  4. Replies: 1
    Last Post: 03-01-2014, 07:10 AM
  5. [SOLVED] How to draw a chart horizontal axis and vertical axis
    By kiany406 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-17-2012, 02:56 PM
  6. Replies: 2
    Last Post: 03-11-2011, 09:02 AM
  7. Replies: 6
    Last Post: 12-07-2010, 02:54 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