I have been given this document (attached to this post) - I didn't create it but have been asked to work with it. In the chart from Row 2 to Row 26, shows projects as bars to indicate their duration. They have a start date, populated from the Begin column on Worksheet 2. The project duration comes from the Duration column on Worksheet 2.
However, I can't work out how to get the dates on the Axis of the chart to change. Currently, the dates on the chart are dates in 2016. My projects started in 2018 at the earliest, so they don't even appear on the chart. When I put 2016 dates in the Begin column, those projects appear on the chart.
I want the date range shown on the chart to reflect the dates in the Calendar column on Worksheet 2. How can I do this?