May 01 2021 07:22 AM
Hi, I am a Mac user (macOS Catalina), with the office and the license from my university.
I have a problem with Excel regarding graphics. I can not modify the limit of the axis.
Could you help me?
May 01 2021 08:20 AM
@Raffa1093 Usually, you can right-click (or two-finger click on the touchpad) on an axis and something like in the picture should come up. Here you can set all sorts of axis options.
May 01 2021 08:26 AM
@Riny_van_Eekelen Hi, thanks for your time.
Yes, I have done the right click and this screen come up. But the limit of the axis are fixed, I can not move them in another range. For example the fixed range for the horizontal axis is 0-400 and I want to set it to 200-400 but it moves it always to zero.
Raffaella
May 01 2021 08:39 AM
@Raffa1093 What kind of chart? Can you upload a file with a "problem" chart? Remove any confidential information though.
May 01 2021 08:45 AM
@Riny_van_Eekelen yes for sure, here it is a problem chart as an example. the limits of both principal and secondary axis are fixed.
May 01 2021 08:58 AM
@Raffa1093 Can't replicate the problem and could change the horizontal axis to start at 200 without a problem, But, I have read about a similar problem on Excel for Windows where to problem was caused by a regional setting in the thousand and decimal separators, Perhaps, something unusual happened in the regional settings on your Mac. Press the Apple logo (top left), System Preferences... , Language & Region and then Advanced....
My settings look like this:
As said, I have no problems with changing the chart axis.
May 01 2021 09:07 AM