View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Darlene Darlene is offline
external usenet poster
 
Posts: 27
Default 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.