Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
plot schedule-type data in graph, date and times as x & y axes
want to plot schedule-type data on graph x axis is 30 days of month and 3
rooms per day; y axis is hour of day from 6am to 8pm in 15min increments, want to plot for say, the 3rd of the month in room 1: 7am-8:15, 10:30-11:15, 1145-1400, 1415-1530, 1600-1730, then other times for room 2, for each day of the month, several rooms per day. Is this impossible- if impossible in Excel, then is there another program that can do this??Thanx! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
plot schedule-type data in graph, date and times as x & y axes
weblun,
What I came up with is this: Format column as time "13:30" Column B starting at cell B2 Enter "06:00" without the "" Cell B3 enter formula "=B2 +(15/1440)" This will add the 15 minute offset. Then copy B3 down to B58 In row1 Column C thru Column AF Enter 1 thru 30 for your days of the month. Your next step is to select cells for each room, merge the cells and enter text "Room 1" or "Room 2" or "Room 3". To make it easy for updating, I would do everything except adding the room times on Sheet1. Then select the block to the left of "A" and above "1" to select the whole sheet, then select copy. Select Sheet2, select the same block as Sheet1 and paste. This will give you a template. hth "weblun" wrote: want to plot schedule-type data on graph x axis is 30 days of month and 3 rooms per day; y axis is hour of day from 6am to 8pm in 15min increments, want to plot for say, the 3rd of the month in room 1: 7am-8:15, 10:30-11:15, 1145-1400, 1415-1530, 1600-1730, then other times for room 2, for each day of the month, several rooms per day. Is this impossible- if impossible in Excel, then is there another program that can do this??Thanx! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you plot a graph with 3 axes e.g. xyz values on Excel? | Charts and Charting in Excel | |||
How do I plot an XY (scatter) graph with two Y axes? | Charts and Charting in Excel | |||
How to plot Date Ranges on Same Graph | Charts and Charting in Excel | |||
How do I plot a 3D graph when I have 3 columns of data? | Charts and Charting in Excel | |||
Want to plot a graph using data from 2 different worksheets in sam | Charts and Charting in Excel |