Should allow: "Value (X) axis crosses at *-MINIMUM-* value

Similar Threads:

1.Need PivotChart x axis to cross Y axis at minimum Y axis value

I see an option to have x cross y at max y, but how can I say min y?

2.Hiding Values Below Z Axis Minimum Value on Axis Charts

I want to use an area chart to show values for data series above a certain 
minimum Z axis value. Unfortunately, I can't find a way to hide parts of 
series that have values below this minimum. The chart shows a continuation of 
the series as though the values were AT the minimum. I've also tried to 
manually clear cells in the table that have values less than the mimum but 
that hasn't worked. Any suggestions?

3.Value (Y) axis crosses between categories and Secondary Value (Y) Axis

Hi all -

I have 7 series on my chart
Series 1 is column chart - may be area chart eventually (2007 data)
Series 2 is column chart 2008 data
Series 3 is column chart 2007 avg
Series 4 is a column chart 2008 avg
Series 5 is a line chart (32,0 benchmark)
Series 6 is a line chart (points to column chart for 2007 avg, I then
add text to right to explain the column)
Series 7 is a line chart (points to column chart for 2008 avg, I then
add text to right to explain the column)

I would like the column charts for 2007 and 2008 data to be flush to
the origin (12 data points each year)
I would like the benchmark line chart of 32 to span the chart area
from left to right (16 data points)

>From what I've read, the way to accomplish this, is to clear the tick
mark from Value (Y) axis crosses between categories when formatting
the x axis.

However, when I do that, the data point for 2007 closest to the origin
appears cut-off on left side of column

I more or less posted this information on Ozgrid a few days ago
(Ozgrid is now down until Nov. 13 according to the site). Andy Pope
replied that if I move the line charts to the Secondary Value (Y)
Axis, that would resolve the problem.

I must be doing something wrong. I did assign the line chart to
Secondary Value (Y) Axis and then cleared the tick mark on the x axis:
Value (Y) axis crosses between categories. However whatever datapoint
is closest to the Primary Y Axis disappears entirely

What am I doing wrong here?
Send a confidential e-mail for a sample copy of the workbook
Best regards,
-markc

4.Changing value of chart axes based on the minimum value of the plotted series

Hi,

I am trying to create a code to define the minimum value of the Y-axi
based on the minimum value of the plotted series.  Something wrong wit
the code.   Perhaps anyone give me an idea how to do this!!!
Thanks and more power!!!

With ActiveChart.Axes(xlValue)
.Select
dblMin = .MinimumScale
End With     
With ActiveChart.SeriesCollection(SeriesNo)
.Select 
nminValue =  min(.Values = "=Table1!R1C1:R10C10")  
<------Perhaps somethig wrong with this line.
End with

If dblMin = 0 then 
dblMin = nminValue
With ActiveChart.Axes(xlValue)
.select
.MinimumScale = dblMin
end with
end If


BR,
Bil

5.Using a cell reference as the axis value for Horizontal axis crosses

Is there any way of referencing a cell as the value in the "axis
value" area of the "Format Axis dialog box. I am currently entering a
number i.e. 2.5. I would like to be able to have this number change
when a user enterer a value in a cell?  Would it have to be VBA code
or is there another way?

6. Can't get the x-axis to cross at value 0 for both y-axes

7. X-axis to cross Y-axis at avrg Y-value

8. Minimum Value & Cell Cross Referencing