+ Reply to Thread
Results 1 to 3 of 3

need a simple line chart

  1. #1
    Registered User
    Join Date
    11-08-2013
    Location
    providence, ri
    MS-Off Ver
    Excel for Mac 2011 Version 14.3.8
    Posts
    20

    need a simple line chart

    Hi - maybe i'm just tired but I can't get a basic line chart generated. I've got two columns, one time (left column below), one value (right column below). I want time on x-axis plotted against values on y. I keep getting a msg about sparklines (funny, Excel forum spell check doesn't recognize that word and neither do I!), when I try to forge ahead recv error message 'bout how my data range doesn't fit, etc. Thx for your help!


    15:34 22.8
    15:34 95.3
    15:35 163.3
    15:35 162.8
    15:36 163.7
    15:36 163.9
    15:37 163.7
    15:37 165.2
    15:38 165.0
    15:38 167.1
    15:39 168.1
    15:39 166.9
    15:40 167.9
    15:40 170.0
    15:41 184.8
    15:41 189.2
    15:42 190.5
    15:42 188.8
    15:43 189.3
    15:43 188.1
    15:44 183.7
    15:44 188.1
    15:45 188.1

  2. #2
    Registered User
    Join Date
    12-06-2016
    Location
    India
    MS-Off Ver
    2007
    Posts
    72

    Re: need a simple line chart

    Hi,

    Check your time column whether it is in time format or not, if not press ctrl + 1 and format the same as time

    select you data go to insert -> choose line chart , its done

  3. #3
    Registered User
    Join Date
    11-08-2013
    Location
    providence, ri
    MS-Off Ver
    Excel for Mac 2011 Version 14.3.8
    Posts
    20

    Re: need a simple line chart

    Thx. I'd already formatted as time, but re-did it and chose a diff format and it worked.

+ 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. Simple Scatter/Line Chart
    By BenHatton in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-28-2016, 08:03 AM
  2. Simple Scatter/Line Chart
    By BenHatton in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-28-2016, 04:47 AM
  3. [SOLVED] How do I make a simple 2-point line chart?
    By helen269 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-31-2016, 04:36 PM
  4. Simple line chart with buttons to choose data sets
    By brucemc777 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-20-2014, 10:07 PM
  5. Unable to display chart with two different
    By abb16ott in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-03-2013, 07:30 AM
  6. Plot a simple line chart with specific range
    By GDM69 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-21-2013, 10:17 AM
  7. To Add a Simple Line Through My Chart
    By Clerk13118 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-18-2008, 06:49 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