LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default Horizontal Axis Options Changing

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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a cell reference as the axis value for Horizontal axis crosses [email protected] Charts and Charting in Excel 4 January 25th 08 01:59 PM
make chart with both horizontal-x axis vertical-y axis CEmery Charts and Charting in Excel 1 December 19th 07 07:11 PM
How do I force a secondary horizontal axis to act as a date axis? The_Tim Charts and Charting in Excel 5 July 6th 07 05:18 AM
I want to do a horizontal list - only 4 options chosen with mouse Dirty Monkey Excel Discussion (Misc queries) 5 November 9th 05 10:34 PM
Problems with Excel Horizontal arrays with regional options using. Dr. Strangelove Excel Discussion (Misc queries) 0 January 6th 05 03:41 PM


All times are GMT +1. The time now is 08:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"