Scale Tab in Format Axis in Excel 2000 Charts

Posts
2
Registration date
Friday June 1, 2018
Last seen
June 2, 2018
- - Latest reply: skeezix
Posts
2
Registration date
Friday June 1, 2018
Last seen
June 2, 2018
- Jun 2, 2018 at 10:52 AM
Hello,
Using Excel 2000 charts, in some files, when I right-click on the horizontal (Date) axis, select the Scale tab in Format Axis, I get a "Time (X axis) scale" with Minimum, Maximum, Base unit, and other values I can change.

In other files, I get a "Category (X) axis scale with 3 variables that I can change.

How can I change those charts so I always get the "Time (X axis) scale" ?
See more 

Your reply

2 replies

Posts
10909
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 7, 2018
0
Thank you
What other files? Update your version of Excel!
Respond to ac3mark
Posts
2
Registration date
Friday June 1, 2018
Last seen
June 2, 2018
0
Thank you
These are all Excel 2000 files. All of the files contain line charts. All of the charts in most of the files function "normally", but all of the charts in some of the files exhibit the problem. Once again, the problem is:

When I right-click on the horizontal (Date) axis, select the Scale tab in the Format Axis DB, I get a "Category (X) axis scale with 3 variables that I can change. What I want is a "Time (X axis) scale" with Minimum, Maximum, Base unit, and other values that I can use to change the dates that the charts illustrate.

Excel 2000 has worked fine otherwise on my system, and the user interface of the update (Office 2016) is too clunky to have to relearn.
Respond to skeezix