Excel Grant Chart

[vdberg20]

Hi, I created a stacked bar chart to reflect as a gant chart and show the movement in between 2 dates as stages however the x axes doesnt give me the option to change to "months" and spreads the data over many years instead of just over 2 or 3 year spread by month.

Thanks for your advices

 

[NateSC]

Is this close to what you want?

For the formatting issue, it is using 1/1/1900 as the smallest number on your chart. If you select the x-axis, format axis, and change the Minimum and Maximum bounds to 1/1/2022 and 1/1/2025 respectively, it will calculate the date number relative to 1/1/1900 (i.e. 44562.0 and 45658.0).

To plot it so that you show the time to hire, you need to calculate the days between recruitment and hire and plot that number (see column E "Delta").

Cycle Test Data.xlsx
	B	C	D	E
1				Delta
2	1	5/1/2023	5/1/2023	0
3	18	5/1/2023	5/1/2023	0
4	10	5/1/2023	6/12/2023	42
5	3	5/1/2023	10/28/2023	180
6	21	5/1/2023	10/28/2023	180
7	11	6/12/2023	9/12/2023	92
8	4	7/30/2023	1/26/2024	180
Sheet2

Cell Formulas
Range	Formula
E2:E8	E2	=D2-C2

 

[vdberg20]

Many thanks, I cannot get the chart to display the same look, how is it formatted?

 

[NateSC]

Many thanks, I cannot get the chart to display the same look, how is it formatted?

For the axis, select the X-axis, select the bottom axis labels, right click, select format axis.
In the Format Axis pane, change the Number (at the bottom of the list) to Date format. Then type your date ranges in the Minimum and Maximum values.

To change the Data, right click your Employment Start Date (the orange bars on your sheet), choose Select Data
Under Legend Entry (Series), select the Employment Start Date series, click Edit, then change the range it is using to point to the Delta column (or what ever you chose to call it).

 

[vdberg20]

Thank you very much! I just had to read your instructions carefully, works a charm.