+ Reply to Thread
Results 1 to 2 of 2

Help creating graph from multiple data

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    Help creating graph from multiple data

    Hi all,

    I am having difficulties graphing some data that I have. I have included the excel file below if this helps. I want to graph two things against one another, but each of the two sets of data has five columns of information. The 'X' axis should be the DN from the K column, and the 'Y' axis should be the DN from the B column. I want to graph the data in terms of its relative abundance- the numbers of data points are given, as well as the percent of the total that this consists of. I ultimately want to do regression analysis on these two data sets, but I just want to start with creating a graph first. I know how to create a normal graph, but I'm pretty lost about how to do this. Any input at all would be appreciated. Thanks.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Help creating graph from multiple data

    So far I have something that looks like the graph I've attached below. The first graph is what I have so far, with one set of values as the X axis and another as the Y axis. However, I can't figure out how to graph two sets of data on the same line without creating two lines. Ideally I would like to create a graph that looks like the second picture shown below. Thanks again. goodgraph.jpgbadtestgraph.jpg

+ 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. Creating multiple series bar graph
    By wayneknox01 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-26-2012, 07:54 AM
  2. [SOLVED] Creating Graph/Chart for some Data
    By ur2l8 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 04-22-2012, 03:17 PM
  3. creating graph from multiple worksheets
    By inuklm in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 07-02-2009, 07:18 AM
  4. Creating one Graph for Multiple WorkSheets
    By Markva in forum Excel General
    Replies: 4
    Last Post: 08-20-2008, 11:57 AM
  5. Creating a graph from data
    By npodges in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2007, 04:30 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