+ Reply to Thread
Results 1 to 3 of 3

simple line chart with dates on the horizontal axis and increasing count on vertical

  1. #1
    Registered User
    Join Date
    09-26-2021
    Location
    GTA, Canada
    MS-Off Ver
    Office 365
    Posts
    2

    Question simple line chart with dates on the horizontal axis and increasing count on vertical

    What I want is very simple but I confess I have no idea how to do it despite googling. I think the newer table wizard is just not getting through my rapidly aging brain.

    I'm editing my novel and I want to keep track of my progress to keep motivated.

    I have a very simple table with dates on A and my progress in terms of pages edited in total in B and as a percent of the total page count in D.

    All i really want is a simple line chart with the dates on the horizontal axis and two scales on the vertical axis, one showing total pages edited (B) and one showing percent edited (D), with a red line at the 100 mark to show me making progress for D.

    The attached excel shows those values.

    If two scales on the vertical are not possible then it's really just column D that's the most important.
    Attached Files Attached Files
    Last edited by Azih; 09-26-2021 at 09:57 AM.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: simple line chart with dates on the horizontal axis and increasing count on vertical

    Is this anywhere near what you're looking for?

    Blue line is the page number plotted against the primary axis (left side).
    Orange line is percent completed and red is the target percentage, plotted against the secondary axis (right side).
    Add new entries in the first blank row under the table and both the table and the chart will adjust to suit.

    Make sure you add 100 in each new row in the new column I've added at the end.

    Hope it helps.

    BSB
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-26-2021
    Location
    GTA, Canada
    MS-Off Ver
    Office 365
    Posts
    2

    Re: simple line chart with dates on the horizontal axis and increasing count on vertical

    Hey, thanks so much for the help! Unfortuanately I can't download your file even though I'm logged in (as I can post) but when I click download the website says I'm not logged in and won't accept my username password.

    Could I trouble you to throw the file up in some other file sharing service that I can quickly download?

+ 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. Replies: 0
    Last Post: 12-03-2020, 04:47 AM
  2. Replies: 2
    Last Post: 06-28-2019, 03:35 AM
  3. How change vertical alignment of dates in horizontal axis of chart?
    By fidgetyFingers in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-09-2018, 03:14 AM
  4. [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
  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: 6
    Last Post: 12-07-2010, 02:54 PM
  7. Chart using one column as vertical axis and others on horizontal axis!!!
    By nandhamnk in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-28-2007, 09:40 AM

Tags for this Thread

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