How to set automatic axis

Hi guys,

I have a horizontal bar chart named Project Date. This chart has Automatic y-axis with task names. How do I make it so the dates on the x-axis is also automatic? I want the auto date to range from A32- A123.
Or I want to be able to select the bounds on y-axis as tasks and auto select bounds based on data for x-axis(dates)


Thank you in advance!!