 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / May 2008graphing data vs time for different patients
Hello I have 10 patients who have had blood test X measured on different dates through 2007. I'd like to plot all 10 lines on the same graph showing the variability of the data points. I can plot all 10 patients' data but versus only one patient's set of dates. Any suggestions as to how to get it to plot all 10 patients vs their respective times? Patient 1 Date 1/1/01 2/1/02 3/1/01 4/1/01 5/1/01 Test 4 5 4 2 0 Patient 2 Date 1/15/01 2/15/01 3/1/01 7/1/01 12/1/01 Test 6 6 1 9 5 Etc...... I tried the XY plotter and inputted each patient as a different series. It worked. But after the 4th patient I wondered, sheesh, is there an easier way to do this for 200 patients?! > Hello > I have 10 patients who have had blood test X measured on different dates [quoted text clipped - 9 lines] > Test 6 6 1 9 5 > Etc...... If you can arrange your data in an orderly fashion, this utility may help: http://peltiertech.com/Excel/ChartsHowTo/QuickChartUtility.html or you could try to develop your own code to save yourself the tedium: http://peltiertech.com/Excel/ChartsHowTo/VBAExcelXYCharts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ >I tried the XY plotter and inputted each patient as a different series. It > worked. But after the 4th patient I wondered, sheesh, is there an easier [quoted text clipped - 17 lines] >> Test 6 6 1 9 5 >> Etc...... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.