Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting mixed data
Good morning, hoping you can assist me with figuring out how to chart
different data. Some of the data is total number of patients seen and then some of it is average waiting time for patient to be seen. The problem I am encountering is the total number of patients is using numbers while the average waiting time is like 2:30 (2 hours & 30 minutes). When I try to chart this information, the data series does not show up for the average waiting time and the hours and minutes will not show. Do I need to separate the data and do two different charts? Thank you. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting mixed data
You could do two separate charts, or select one series and plot it on the
secondary axis. I suspect the problem is that number of patients is much larger than time. 2:30 is a fraction, equal to (2.5/24), so it will hardly be visible next to data on the order of, what, dozens? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Darlene" wrote in message ... Good morning, hoping you can assist me with figuring out how to chart different data. Some of the data is total number of patients seen and then some of it is average waiting time for patient to be seen. The problem I am encountering is the total number of patients is using numbers while the average waiting time is like 2:30 (2 hours & 30 minutes). When I try to chart this information, the data series does not show up for the average waiting time and the hours and minutes will not show. Do I need to separate the data and do two different charts? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mixed data types in a cell | Excel Discussion (Misc queries) | |||
DCount, with mixed type data | Excel Discussion (Misc queries) | |||
SORT MIXED DATA | Excel Worksheet Functions | |||
Mixed Data Handling | Charts and Charting in Excel |