View Single Post
  #1   Report Post  
arhooley
 
Posts: n/a
Default Excel has created Y-axis increments of .14!

The format for my data is 0:00, chart is plain old bar.

Lowest value = 0:01

Highest value = 1:26

Excel has created a Y-axis with minimum 0:00 (fine) and max 1:26
(huh?). In between are 6 major units with increments of .14.

How can I change this so the maximum value is, say, 1:30 and the
increments are .10? I've fiddled for half an hour with the Value Axis
format options, but nothing works.

Thanks.