Excel axis help

Copper Contributor

I need help changing the value of my horizontal axis.  I’ve tried very setting possible and nothing has worked.  Excel is the issue and is not working properly.  I need help asap.

 

Samantha

3 Replies

@Sturner007 You need to be more specific. Can you upload a screenshot of share the file via OneDrive or something similar?

@Riny_van_Eekelen yes I took a screenshot on my phone.. I’m doing the work on a computer.

 

Notice the horizontal axis.  Excel will not allow me to change it to say 2018 2019 2020 2021 2022.  I have tried every setting/option and have not figured it out.  Talked to support and they can’t figure out why excel is not working properly.  I need the years to align with the dots in the chart.  That’s it.  Apparently  this is way more complicated than it should be!

 

4A13331B-9005-46ED-9694-39855D5D981F.png

@Sturner007 Thanks, but the picture doesn't not show much. Can't you share the file?