Value (Y) axis crosses between dates

  • Thread starter Thread starter Frager
  • Start date Start date
F

Frager

I would appreciate it if someone could point me to a site where I can get
information on the use of/thinking behind:



1. Value (Y) axis crosses between dates

2. Value (Y) axis crosses at maximum value



that appears under 'Scale' in the 'Format Gridlines' dialog box.



Thanks
 
1. Value (Y) axis crosses between dates

This means the axis crosses between dates (or categories) rather than at a
date (or category). In a line or column chart, this means that a data marker
or column is never split on the vertical axis.

By default, Line and Column charts have this item checked, while Area charts
have it unchecked, so the colored area goes right up to the edges of the
plot area.
2. Value (Y) axis crosses at maximum value
Click to expand...

This means Excel will place the axis at the maximum of the category (X)
axis, rather than at the default of zero (or the minimum of the axis if the
minimum is greater than zero). A primary axis has this unchecked by default,
while a secondary axis has it checked, so the secondary does not lie right
on top of the primary axis. There's no "crosses at minimum", though I wish
there had been. If you set a value for "Value (Y) Axis Crosses At", this box
will be unchecked.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Thanks, Jon for the information.

Frager
|> 1. Value (Y) axis crosses between dates
|
| This means the axis crosses between dates (or categories) rather than at a
| date (or category). In a line or column chart, this means that a data
marker
| or column is never split on the vertical axis.
|
| By default, Line and Column charts have this item checked, while Area
charts
| have it unchecked, so the colored area goes right up to the edges of the
| plot area.
|
| > 2. Value (Y) axis crosses at maximum value
|
| This means Excel will place the axis at the maximum of the category (X)
| axis, rather than at the default of zero (or the minimum of the axis if
the
| minimum is greater than zero). A primary axis has this unchecked by
default,
| while a secondary axis has it checked, so the secondary does not lie right
| on top of the primary axis. There's no "crosses at minimum", though I wish
| there had been. If you set a value for "Value (Y) Axis Crosses At", this
box
| will be unchecked.
|
| - Jon
| -------
| Jon Peltier, Microsoft Excel MVP
| Peltier Technical Services
| Tutorials and Custom Solutions
| http://PeltierTech.com/
| _______
|
|
| | >I would appreciate it if someone could point me to a site where I can get
| > information on the use of/thinking behind:
| >
| > 1. Value (Y) axis crosses between dates
| >
| > 2. Value (Y) axis crosses at maximum value
| >
| > that appears under 'Scale' in the 'Format Gridlines' dialog box.
| >
| > Thanks
|
|
 
Back
Top