Time chart
Is it possible to show a chart of times a meeting is booked.
I have a spreadsheet with dates, start time and end times. What I want to see is the date across the X axis, hours from 00:00-00:00 up the Y axis then show bars for example just between 09:00-10:30 and 13:00-15:00. If not in a chart can you mabye suggest an alternative. Many Thanks |
Time chart
Hi,
Sounds like you need information on gantt charts. Normally the bars are horizontal but the principle should work just as well with columns. Anyway see Jon Peltier's article on gantt charts, http://pubs.logicalexpressions.com/P...cle.asp?ID=343 and a collection of links on his own site, http://peltiertech.com/Excel/Charts/GanttLinks.html Cheer Andy Pendelfin wrote: Is it possible to show a chart of times a meeting is booked. I have a spreadsheet with dates, start time and end times. What I want to see is the date across the X axis, hours from 00:00-00:00 up the Y axis then show bars for example just between 09:00-10:30 and 13:00-15:00. If not in a chart can you mabye suggest an alternative. Many Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 10:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com