Wednesday, November 11, 2009

Creating a Combination Column & Line Chart

In healthcare we often want to compare data from different sources to see if there is any type of relationship; for example, comparing staffing with patient outcomes.  An activity for the Thede & Sewell Informatics and Nursing textbook, chapter 24, asks the learner to create a chart that compares the number of patient falls and pressure ulcers with staffing using the percentage of registered nurses. The mixed type of chart is not addressed in the textbook and may pose as a challenging task.  The task is easier than it might appear. It is a two step process.

If using Excel 2007
  1. Highlight the entire chart and then select the Column Chart type.
  2. Right-click on the Percentage of Registered Nurses column and select Change Series Chart Type from the menu - and select Line with Markers
The resulting chart should like like the graphic below.



A website at http://www.techonthenet.com/excel/charts/column_line.php may be helpful for earlier versions of Excel.

No comments :

Post a Comment