+ Reply to Thread
Results 1 to 2 of 2

How to plot with multiple/different info on x-axis?

  1. #1
    Registered User
    Join Date
    10-20-2010
    Location
    San Diego, CA.
    MS-Off Ver
    Excel 2006
    Posts
    1

    How to plot with multiple/different info on x-axis?

    Hello,

    I have data which is taken daily. I save that in one column. The next column is the time when the data is taken. Thus, I have 2 columns that define the x-axis.

    I wish to make a plot BY DAY, with the data plotted according to a fine-resolution using time on the x-axis. How do I do this?

    To be more specific --- I have hypertension and take regular BP measurements. It's somewhat random as to when I take the measurements during the day. The x-axis should be:

    9am 1pm 9pm 8am 10am 7pm 8am 3pm 7pm
    Oct-1 Oct-2 Oct-3

    The vertical axis is a single axis and I wish to scatter plot the systolic and diastolic measurements, plus pulse.

    After I have this plot, I'd also like to be able to sort by "morning/afternoon/evening" --- so I can create grouped plots to see if readings tend to be higher in the evening, etc...

    Any help is appreciated!!

    Thank you!

  2. #2
    Valued Forum Contributor blane245's Avatar
    Join Date
    02-20-2009
    Location
    Melbourne, FL
    MS-Off Ver
    Excel 2010
    Posts
    649

    Re: How to plot with multiple/different info on x-axis?

    I think I have the basic idea, but need an example. Could you post an example workbook with the data in it and we can go from there.
    Bob
    Click my star if my answer helped you. Mark the thread as [SOLVED] if it has been.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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