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: 124
Default Formatting 'X' Axis -- 2 fundamental differences

I have many Line-type charts, all of which have as the X axis, the DATE.

When I right click on the "X" axis, I get 2 distinctly different type
options under "SCALE" as follows:

1) FORMAT AXIS
Patterns Scale Font Number Alignment

minimum

maximum

base unit

major unit

minor unit

value (Y) axis
crosses at

Date in Reverse Order Value (Y) axis crosses between dates

Value (Y) axis crosses at maximum value


OR...

I get:

2) Patterns Scale Font Number
Alignment

Value (Y) axis crosses
at category number

Number of categories
between tick-mark labels

Number of categories
between tick marks

IN ANY EVENT, I FAIL TO UNDERSTAND WHY, UNDER "SCALE", WHEN I FORMAT THE
"X" AXIS,
I GET THESE 2 OPTIONS DESCRIBED ABOVE, BECAUSE..

"I BELIEVE THE CHARTS ARE IDENTICAL!"

Can someone please help me???

Thank you,

FLKulchar




 
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
charting extreme number differences on x-axis MacGyver@IFC Charts and Charting in Excel 1 April 28th 08 11:36 PM
Fundamental problem with IF statement David F Excel Worksheet Functions 3 May 17th 05 03:42 PM
Fundamental problem with IF statement-None worked David F Excel Worksheet Functions 3 May 13th 05 12:37 AM
Fundamental problem with IF statement David F Excel Worksheet Functions 4 May 12th 05 09:34 PM
Formatting X and Y axis' Joey041 Charts and Charting in Excel 1 February 19th 05 05:29 AM


All times are GMT +1. The time now is 09:06 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"