+ Reply to Thread
Results 1 to 3 of 3

Help creating special type of line chart

  1. #1
    Registered User
    Join Date
    Kent, England
    MS-Off Ver
    Excel 2007

    Help creating special type of line chart


    I would greatly appreciate your help.

    I have just completed a medical study looking at 3 groups A, B and C. All these groups undergo the same treatment and are followed up to see if several variables improve over time.

    I would like to create a chart that demonstrates the following:

    1. x axis (time in days)
    2. y axis (variable being followed up)
    3. I would like to create a line chart that shows how the variable changes with EACH patient over time. So in the end I would have a line chart that shows each patient's progress (additionally with groups A, B and C superimposed on the same chart).

    Is this possible with excel?

    Many Thanks

  2. #2
    Forum Expert
    Join Date
    The Netherlands
    MS-Off Ver
    Office 365

    Re: Help creating special type of line chart

    I bet you get better anwers on your question, if you follow the advice in the link below.

    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Guru
    Join Date
    North America
    MS-Off Ver
    2002/XP and 2007

    Re: Help creating special type of line chart

    A sample file probably would help quite a bit to get specific suggestions.

    In general, I find that most of these kind of charting questions end up really being spreadsheet type questions. If the data is laid out in the spreadsheet in an undesirable way, then you will have difficulty creating the chart. If the data are laid out well, then the chart will be easy to create.

    IMO, the key to getting a separate line for each patient and for each group is to get the data in the spreadsheet separated out into individual patients and groups. It is hard to give specific suggestions for this, but this might look like:
    Please Login or Register  to view this content.
    This table can then be easily plotted in a line or scatter plot, and each patient will have its own line and own legend entry (if you include a legend).
    I don't know how extensive your data set is, but you might want to be aware that Excel is limited to 255 individual data series and a total of 256000 data points (just in case this is a very extensive study with more than 255 patients).
    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. Changing line cap type for X-Y chart
    By michch in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 12-20-2016, 03:11 PM
  2. [SOLVED] Creating a pivot line chart with no line.
    By ScottLor in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 04-08-2013, 10:38 AM
  3. Difficulty creating a basic line chart without breaks in line plots
    By brharrii in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 04-05-2013, 04:29 PM
  4. Creating a Chart with special features
    By lostinformulas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-28-2007, 04:54 PM
  5. Adding a line Chart Type to a stacked-clustered Chart Type
    By Debbie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-05-2005, 08:06 PM


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