Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to chart
Spreadsheet contains records of apointments that have taken place, including
start and end times of appointments e.g. 12:30 pm to 17:30 pm. Need to produce a chart that has "number of appointments" on y-axis and 15 minute timebands on x-axis. Idea is to visually demonstrate periods of high and low activity. Problem I'm having is working out how many appointment instances occur for each 15 minute timeband. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to chart
This page shows a few ways to compile your data into plottable information:
http://peltiertech.com/Excel/Charts/Histograms.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "The Inquirer" wrote in message ... Spreadsheet contains records of apointments that have taken place, including start and end times of appointments e.g. 12:30 pm to 17:30 pm. Need to produce a chart that has "number of appointments" on y-axis and 15 minute timebands on x-axis. Idea is to visually demonstrate periods of high and low activity. Problem I'm having is working out how many appointment instances occur for each 15 minute timeband. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to chart
Thanks Jon.
I didn't know about the Analysis Toolpak - this is going to be a great help and time saver when it comes to charting my data. I still have a problem, however, in splitting the records of each appointment in to 15 minute slots. For example, one appointment has "Appointment ref" = 00001, "Start time" = 9:00 and "End time" = 9:45. I've now got my Bin consisting of 0:00, 0:15, 0:30, 0:45 etc, i.e. have this as the start time of my 15 minute timebands. My example appointment above would therefore fall in to 3 time bands i.e. the 9:00, the 9:15, and the 9:30 timebands in my Bin. I appreciate that this isn't an Excel charting issue so will cross post this in a more appropriate discussion group. Thanks again for your help. Regards, David "Jon Peltier" wrote: This page shows a few ways to compile your data into plottable information: http://peltiertech.com/Excel/Charts/Histograms.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "The Inquirer" wrote in message ... Spreadsheet contains records of apointments that have taken place, including start and end times of appointments e.g. 12:30 pm to 17:30 pm. Need to produce a chart that has "number of appointments" on y-axis and 15 minute timebands on x-axis. Idea is to visually demonstrate periods of high and low activity. Problem I'm having is working out how many appointment instances occur for each 15 minute timeband. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to chart
Thanks Jon.
I didn't know about the Analysis Toolpak - this is going to be a great help and time saver when it comes to charting my data. I still have a problem, however, in splitting the records of each appointment in to 15 minute slots. For example, one appointment has "Appointment ref" = 00001, "Start time" = 9:00 and "End time" = 9:45. I've now got my Bin consisting of 0:00, 0:15, 0:30, 0:45 etc, i.e. the start time of my 15 minute timebands. My example appointment above would therefore fall in to 3 time bands i.e. the 9:00, the 9:15, and the 9:30 timebands in my Bin. I appreciate that this isn't an Excel charting issue so will cross post this in a more appropriate discussion group. Thanks again for your help. Regards, David "Jon Peltier" wrote: This page shows a few ways to compile your data into plottable information: http://peltiertech.com/Excel/Charts/Histograms.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "The Inquirer" wrote in message ... Spreadsheet contains records of apointments that have taken place, including start and end times of appointments e.g. 12:30 pm to 17:30 pm. Need to produce a chart that has "number of appointments" on y-axis and 15 minute timebands on x-axis. Idea is to visually demonstrate periods of high and low activity. Problem I'm having is working out how many appointment instances occur for each 15 minute timeband. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting values in a bar chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |