Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with x axis as timeline; y axis as specific actions
I am trying to find out if anyone knows of a template that I can use or a
chart I can tailor.... what I want to do is show: x axis would start out with a tick mark for 15 min, then one for 30 min, another for 45 min, and finally one mark for 60min/1 hour....then another tick further down the x axis for hour #2, then further equal distance down for hour # 3, ... to 8 hour mark which would equal one work day...then further down the x axis for day #2, then day #3, then day #4, and finally day #5, which would equal one work week. On the y axis, I need to put individual actions that a company might be taking, and showing on the x axis where those actions are taking place on the timeline x axis. Does anyone know how to do this, as I thought it up at 4am the other morning when I couldn't sleep, and now I am very lost trying to create such an animal within Excel...and eventual use in a PowerPoint. -- Thanks for any help you can provide. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with x axis as timeline; y axis as specific actions
Hi,
Sounds like a gantt chart. http://pubs.logicalexpressions.com/P...cle.asp?ID=343 http://peltiertech.com/Excel/Charts/GanttLinks.html http://peltiertech.com/Excel/Charts/GanttChart.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "David P" wrote in message ... I am trying to find out if anyone knows of a template that I can use or a chart I can tailor.... what I want to do is show: x axis would start out with a tick mark for 15 min, then one for 30 min, another for 45 min, and finally one mark for 60min/1 hour....then another tick further down the x axis for hour #2, then further equal distance down for hour # 3, ... to 8 hour mark which would equal one work day...then further down the x axis for day #2, then day #3, then day #4, and finally day #5, which would equal one work week. On the y axis, I need to put individual actions that a company might be taking, and showing on the x axis where those actions are taking place on the timeline x axis. Does anyone know how to do this, as I thought it up at 4am the other morning when I couldn't sleep, and now I am very lost trying to create such an animal within Excel...and eventual use in a PowerPoint. -- Thanks for any help you can provide. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to manually switch data from x axis to y axis in line chart? | Charts and Charting in Excel | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel |