excel chart x-axis 'bounds' missing
I tried to practiced the content of the video but there is no 'bounds' option in the Format Axis - Axis options.
How can I adjust the bounds if there is no 'bounds' option?
I'm using Office professional Plus 2019.
thanks for reaching out. Could you provide a snapshot of the menu you can access for the axes in your version of office? I have not used this particular version of office, it is possible that this option is accessed from a different menu
Hi, thank you for your reply.
The problem only occurs when I practice with 'line_chart_data' file, and not 'line_chart_excel' file.
Thanks for posting the screenshots and the clarification. In that case it might be that the problem is with the data type of the files.
line_chart_data is of csv format.
line_chart_excel is and xlsx document.
It's possible that you're not able to get the same functionality with the csv format or possibly that there is some encoding issue, which causes the problems.
I'd suggest, if this problem occurs to try and save the data files in a different format - switch from csv to excel or some of the open office formats. Or try a different encoding for the csv file and check if that resolves the problem.
I had the same problem. It is because the Date column is not in date format. To solve this, I used the "Text to Columns" option to separate the date using the separator "/", and then I joined the columns using the =DATE() function.