+ Reply to Thread
Results 1 to 2 of 2

3 Data Series Line Graph Help

  1. #1
    Registered User
    Join Date
    02-05-2016
    Location
    Washington, DC, USA
    MS-Off Ver
    MS Office 2010
    Posts
    1

    3 Data Series Line Graph Help

    I need help in plotting my 3 data series.
    Goal is a constant number
    My score changes
    Dept AVG changes.

    File Attached.Effeciency.xlsx

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

    Re: 3 Data Series Line Graph Help

    I think it would help if we understood exactly what difficulty you are having. Are you able to insert a chart? If, so what is right and wrong with the chart Excel creates? Is it related to formatting one or more chart elements? How I would expect to create a line chart from this:

    1) Delete/Clear A2. For some reason, Excel likes to see the upper left corner of a chart data source empty when a chart like this is created.
    2) Select A2:D14
    3) Insert -> Line chart -> Line chart
    4) Format and edit chart as needed.
    5) Enter "Month" into A2, if I want that value present in the final spreadsheet.
    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. How to add a Series without the graph Line?
    By Rgauer in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-15-2014, 03:33 AM
  2. Replies: 0
    Last Post: 03-26-2013, 08:38 PM
  3. line graph with multiple data series vs. time/date leaves out most data
    By Lee Collins in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-18-2012, 10:54 AM
  4. Line graph data series help needed!
    By jackdsargeant in forum Excel General
    Replies: 1
    Last Post: 11-07-2010, 04:58 PM
  5. Problem charing w/line graph when a series has missing data points
    By tvdij in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-08-2008, 04:05 AM
  6. Add series to line graph
    By Barb in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-08-2005, 01:10 PM
  7. How do I add one line series to a bar graph?
    By Elliott in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-13-2005, 04:05 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