Scale Tab in Format Axis in Excel 2000 Charts

skeezix 2 Posts Friday June 1, 2018Registration date June 2, 2018 Last seen - Jun 1, 2018 at 04:36 PM - Latest reply: skeezix 2 Posts Friday June 1, 2018Registration date June 2, 2018 Last seen
- 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

ac3mark 10237 Posts Monday June 3, 2013Registration dateModeratorStatus August 13, 2018 Last seen - Jun 1, 2018 at 04:36 PM
0
Thank you
What other files? Update your version of Excel!
Respond to ac3mark
skeezix 2 Posts Friday June 1, 2018Registration date June 2, 2018 Last seen - Jun 2, 2018 at 10:52 AM
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