+ Reply to Thread
Results 1 to 2 of 2

Line charts with a large amount of data

  1. #1
    Registered User
    Join Date
    06-19-2018
    Location
    Poland
    MS-Off Ver
    2007
    Posts
    2

    Line charts with a large amount of data

    I have to make a line chart ('F' should be on the vertical axis, 'dL' on horizontal) and another where 'd' is on the vertical axis and 'e' on horizotal one but I don't know how. I'd appreciate any help.
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Line charts with a large amount of data

    This should be a simple chart exercise. Select a cell in the data range for F and dl (columns C&D). Then select the Insert Ribbon and select a chart type of X-Y scatter. Excel should do the rest.

    I did this and both charts look almost identical.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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: 5
    Last Post: 12-28-2018, 03:41 PM
  2. [SOLVED] Help with managing a large amount of data
    By Jlister in forum Excel General
    Replies: 0
    Last Post: 05-17-2018, 06:09 AM
  3. Consolidating a Large Amount of Data
    By troop2011 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2017, 11:49 AM
  4. Pasting large amount of data
    By fredrbcc in forum Excel General
    Replies: 1
    Last Post: 02-13-2015, 09:38 PM
  5. Transposing a large amount of data
    By BTB0923 in forum Excel General
    Replies: 3
    Last Post: 12-03-2014, 01:52 PM
  6. Large amount of data for plotting
    By dharshanie in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-24-2006, 12:15 PM
  7. [SOLVED] $ large amount of Data.
    By confused man in forum Excel General
    Replies: 5
    Last Post: 02-08-2005, 09:06 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