Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
47
Views
Topic starter
Hi, I have a line chart where the x-axis is 16/17 to 29/30, representing years 2016/17 to 2029/30. However, on my chart these dates are coming out as numbers. The first number is -1, and then it jumps up 5 every time. Does anyone have a solution for this? I just want it to say 16/17 ... and so on. When I click select data for the chart, it has the correct values for the horizontal axis but it wont show as such on the actual chart. Has anyone had to deal with this type of issue before?
Thanks.
Posted : 24/11/2020 11:10 am
It sounds like the axis isn't referencing the axis vales correctly as I can't replicate this issue. Are you able to share your file so we can check?
Posted : 24/11/2020 9:19 pm