| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting Data to Compare
I have the following data to chart (Using Excel 2003)
It's for several different hospitals and I want a chart for each hospital. I want to compare 4 quarters from the year 2005 & 2006 (side by side) in a bar graph for each year and then the YTD data as well (side by side). The YTD is the sum of the 4 quarters. I want this all on one chart. The data is as follows: Hospital XYZ Q1 Q2 Q3 Q4 YTD 2005 2134 1958 2647 2016 8755 2006 2149 2034 2457 2314 8954 The chart will have 10 bars, Q1 side by side, Q2 side by side and so on... How should I group the data in order to achieve this end result? ANY help would be greatly appreciated, Karen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Need to compare data in 2 columns and not sure how. | Charts and Charting in Excel | |||
| Charting Filtered Data | Charts and Charting in Excel | |||
| How do I compare data from 2 worksheets to find duplicate entries | Excel Discussion (Misc queries) | |||
| How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
Threaded Mode
