Your Excel Weekly Time Gantt Chart will look like this:įor the chart, you need to select the chart and then press the Switch Row/Column button on the Design Ribbon in order to get our format for this chart. Highlight your chart data range (from A1:AV8) and then go to your Insert Ribbon and choose the Stacked Bar Chart from the Chart group.
Now that we have our data set up, we need to create our Excel Hourly Time Gantt Chart. The 1’s will be hour blocks of time and the zeros will not show up in our chart. NOTE – That your chart and my chart didn’t end at hour 7, but went to hour 24, but it is hard to see on the web when you look at 48 columns of data. The formula might look like this: =if(b2=1,0,1).
24 hr time excel x axis data switch series#
If hour one equals zero, then the fill series should equal 1. For example, if hour one for Monday = 1, then the Fill series 1 for Monday should equal Zero. If the hour was not worked and equals zero, then we need to fill in a 1 for the hour to make sure our data all lines up. This is a formula that looks at the hour and if it equals 1 and was worked then put in a 0. Then you also need to add an additional series for each hour to fill in the data for that hour if it was not worked. You need to create a chart data range that has a 1 for the time worked and a 0 when it is not worked.
This is the first tip/trick to create this Excel Gantt Chart for a Time Series. Donate with PayPal here:ġ) Create Chart Data Series with Time Worked and Fill Series If you found the website and tutorials helpful, please consider donating to keep the lights on.
0 kommentar(er)
