Y-Axis question
I have 7 days worth of data on seperate spreadsheets and seperate charts for
each day showing time of admission, and total patients for each hourly range. I need to make sure each range on the y axis is the same for each chart, but Excel is automatically numbering according to the highest number of patients for that specific day. For example on Sunday's chart, the highest tick mark on the chart is 16 but on Monday, the highest tick mark is 25 because there were more admissions. Is there a way to make them all the same, say set them all to 25? -- Tasha |
Y-Axis question
I found it.....disregard...
-- Tasha "sueshe" wrote: I have 7 days worth of data on seperate spreadsheets and seperate charts for each day showing time of admission, and total patients for each hourly range. I need to make sure each range on the y axis is the same for each chart, but Excel is automatically numbering according to the highest number of patients for that specific day. For example on Sunday's chart, the highest tick mark on the chart is 16 but on Monday, the highest tick mark is 25 because there were more admissions. Is there a way to make them all the same, say set them all to 25? -- Tasha |
All times are GMT +1. The time now is 03:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com