Horizontal Axis Options Changing

Tech-Archive recommends: Fix windows errors by optimizing your registry

Excel 2007

I have noticed that the horizontal Axis options can change in an Excel 2007
chart, which is driving me crazy. On some charts when I open the horizontal
axis options, under Axis options, they start out with "Interval between tick
marks", "Interval between labels" and so on, which is what I expect to see.
On another chart, with the exact same layout and data (just the numbers are
different for the data), when I right click the horizontal axis and choose
Format Axis, the Axis Options start out with Minimum, Maximum, Major Unit,
Minor Unit and so on. The options, Interval between tick marks, Interval
between labels and so on are not there. These are all simple line charts
with a date column and then 2 columns of data (numbers).

So how do I get the "normal" horizontal options back? Why is Excel changing
the Axis options?

.

Relevant Pages

  • Re: How do I plot date against time?
    ... Somehow I got a chart to show the two time series on the y-axis, ... Microsoft Excel MVP ... Date Rise Set ... How do I get the date back on the horizontal axis? ...
    (microsoft.public.excel.charting)
  • Re: How do I plot date against time?
    ... Date, Rise, Set. ... Microsoft Excel MVP ... I understand that the preferred format is an XY chart? ... How do I get the date back on the horizontal axis? ...
    (microsoft.public.excel.charting)
  • Re: Charts Having X Axis Scaled Using Calendar Weeks
    ... Excel 2007 Chart ... Continuous X Y line plot by week at year end. ... Secondary vertical and horizontal axis. ...
    (microsoft.public.excel.programming)
  • Re: Automatic swap of x - and y - axis
    ... Are the values that were plotted on the horizontal axis now plotted on the ... column chart become a bar chart? ... Jon Peltier, Microsoft Excel MVP ...
    (microsoft.public.excel.charting)
  • Re: Plotting multiple Y column data versus single X column in Exce
    ... In Excel 2007, this ability to enter times was forgotten until SP2. ... Jon Peltier, Microsoft Excel MVP ... time format, like 13:30 and then clicked back on Axis Options to return to ...
    (microsoft.public.excel.charting)