Format axis upper and lower limit option missing

When I right-click on the axis and go to format axis options it is not showing options for upper and lower limit and I am sure it was there earlier.
Any ideas?

I have also noticed that this option available for y-axis but not for horizontal one (an x-axis).

Originally Posted by MrShorty

That sounds like your horizontal axis is a category axis, not a value axis. (http://peltiertech.com/Excel/ChartsH...ValueAxis.html ) If your "x-values" are numbers, then you probably want an XY scatter plot instead of whatever chart type you are using.

You are right, it is a category axis. Any chance I can format that in a way I want or do I have to change the range ?
Cheers

Originally Posted by MrShorty

What do "max" and "min" or "upper" and "lower" limit mean on a category axis?

An example spreadsheet that illustrates your data, your chart, and explains what you want to do would likely be very useful.

That's the time in minutes

Originally Posted by MrShorty

If the x axis is "time in minutes", I would tend to use a scatter plot, where max is the longest or latest time and min is the shortest/earliest time. Is there a specific reason you are preferring to stay with a category axis?

Yes, Data are the Temperatures from the Logger and I want to keep it consistent with previous analysis so want to stick with horizontal axis as category.

Originally Posted by MrShorty

Then you probably are "stuck" with changing the range of the data. If you become familiar with the use of "dynamic named ranges", this process can be automated http://www.excel-easy.com/examples/d...med-range.html or put "dynamic named ranges excel" into your favorite search engine.

that's great tip with dynamic ranges, many thanks. Changing dynamic range for category seems nice and quick but adjusting data to same range is time consuming. Any suggestions to get away with it?
Thanks

Originally Posted by newdoverman

One small thing to add; make sure that the times are actually times and not text that looks like time.

Great suggestion, thanks

Originally Posted by MrShorty

I would expect to use a similar "dynamic named range" for the y values, too. So you would end up with two dynamic named ranges: one for the category/x axis values and a second for the y values. If you have more than one data series, then you would have a dynamic named range for each data series.

That's what I will do , Thanks