Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Multiple project timelines in one graph
Hi,
I need to set up a bar chart that shows when and what kind of work we do for different projects throughout the year. What i would like is for the bars to act as a timeline, with one bar for each project. Then, each bar should be split up into different colours to reflect the kind of work required for that project, as we perform different duties depending on the time of year. This is so we can see when we are busy with different projects, and when there are some quieter periods in which to do other work. Any help would be great. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Multiple project timelines in one graph
Hi,
You will need to read up on Gantt charts. http://peltiertech.com/Excel/Charts/ChartIndex.html#G Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "drummanmatt" wrote in message ... Hi, I need to set up a bar chart that shows when and what kind of work we do for different projects throughout the year. What i would like is for the bars to act as a timeline, with one bar for each project. Then, each bar should be split up into different colours to reflect the kind of work required for that project, as we perform different duties depending on the time of year. This is so we can see when we are busy with different projects, and when there are some quieter periods in which to do other work. Any help would be great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am trying to project out a line graph based on data | Charts and Charting in Excel | |||
Timelines in excel | Charts and Charting in Excel | |||
Excel for Timelines | Charts and Charting in Excel | |||
HOW DO I MAKE A BAR GRAPH FOR A SCIENCE PROJECT? | New Users to Excel | |||
conditional formatting and timelines | Excel Worksheet Functions |