excel chart issue

[hehehe]

I just created a excel chart as attached but I found 2 problems

1) the fisrt date of the data source should be 12/3/2021 , but as you can see in the chart , the first date of x-axis is 4/1/2021 , so that this is a gap in the chart ( as shown <-------> ) , could advise how to change the x-axis first date is 12/3/2021 ?

2) as you can see , the y-axis is -200 , 0 , 200 , 400 , how to remove -200 ?

Thanks much

 

[RoryA]

Please consider this the last warning:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

excel chart issue

excel chart issue Excel

www.msofficeforums.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.