+ Reply to Thread
Results 1 to 2 of 2

Line Chart with Multiple Ranges

  1. #1
    Forum Contributor
    Join Date
    10-15-2009
    Location
    Broooklyn, NY
    MS-Off Ver
    Excel 2016
    Posts
    207

    Line Chart with Multiple Ranges

    I am not very familiar with the charts. I have 3 companies. I want to show all 3 companies data as a line chart on one graph, so you should have 3 lines. If you know how to do it, can you also provide instructions as well and do it in the spreadsheet.
    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,835

    Re: Line Chart with Multiple Ranges

    Many chart questions are more about arranging data in the spreadsheet than about creating the chart. I would move B11:B14 into C2:C5 and B18:B21 into D2:D5. Then select A3:D5 -> insert chart -> line or scatter chart.
    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. Chart to show year ranges for time line
    By d0ughb0y in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-19-2020, 02:54 PM
  2. Combine 2 named-ranges for a single series line chart
    By ElmerS in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 12-02-2014, 07:21 PM
  3. Replies: 3
    Last Post: 10-16-2014, 02:01 PM
  4. [SOLVED] Add line chart to bar chart with multiple categories
    By EthanM in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-02-2014, 04:12 PM
  5. Replies: 1
    Last Post: 12-31-2012, 05:31 AM
  6. Replies: 2
    Last Post: 06-15-2012, 03:06 AM
  7. Charts - Line Chart, How to Show data Ranges?
    By chickencoop in forum Excel General
    Replies: 4
    Last Post: 01-06-2009, 08:43 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