Last answered:

05 Dec 2022

Posted on:

17 Apr 2021

1

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.

5 answers ( 0 marked as helpful)
Instructor
Posted on:

19 Apr 2021

0

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

Posted on:

25 Apr 2021

0

Hi, thank you for your reply.

The problem only occurs when I practice with 'line_chart_data' file, and not 'line_chart_excel' file.

image
image

Instructor
Posted on:

05 May 2021

0

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

Posted on:

22 Sept 2022

6

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.
image.png

Posted on:

05 Dec 2022

0

Thanks for the reply. It was really helpful!

Submit an answer