excel chart x-axis 'bounds' missing
Hi.
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.
Thank you.
Hi Minhee,
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
Best,
365 Eli
Hi, thank you for your reply.
The problem only occurs when I practice with 'line_chart_data' file, and not 'line_chart_excel' file.
Hi MINHEE,
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.
Best,
365 Eli
Hi Minhee,
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.
Thanks for the reply. It was really helpful!