Similar Threads:
1.Changing a horizontal axis crosses value using VBA
I have just started trying to learn VBA since the 1st of the year. I
used macro recorder to record changes in the "Format Axis" "Axis
Options" "Horizontal Axis Crosses" "Axis value" or the "CrossesAt"
portion of a chart. Because I wanted to be able to enter a crosses at
value into a cell I added the = Range(). The following code is working
except there is a short wait while the code is executing.
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.Axes(xlValue).CrossesAt = Range("I21")
ActiveSheet.ChartObjects("Chart 2").Activate
ActiveChart.Axes(xlValue).CrossesAt = Range("J21")
ActiveSheet.ChartObjects("Chart 3").Activate
ActiveChart.Axes(xlValue).CrossesAt = Range("K21")
ActiveSheet.ChartObjects("Chart 4").Activate
ActiveChart.Axes(xlValue).CrossesAt = Range("L21")
ActiveSheet.ChartObjects("Chart 5").Activate
ActiveChart.Axes(xlValue).CrossesAt = Range("M21")
ActiveSheet.ChartObjects("Chart 6").Activate
ActiveChart.Axes(xlValue).CrossesAt = Range("N21")
ActiveSheet.ChartObjects("Chart 7").Activate
ActiveChart.Axes(xlValue).CrossesAt = Range("O21")
ActiveSheet.ChartObjects("Chart 8").Activate
ActiveChart.Axes(xlValue).CrossesAt = Range("P21")
ActiveSheet.ChartObjects("Chart 9").Activate
ActiveChart.Axes(xlValue).CrossesAt = Range("Q21")
Here is what I'm trying to do now. If the value in the chart is the
same as in the cell I want to skip the code for that chart. So if the
value in the cell is different need to run. I can't figure out how to
compare the 2 values. This is what I have attempted without sucess.
ActiveSheet.ChartObjects("Chart 1").Activate
If Not ActiveChart.Axes(xlValue).CrossesAt.Value =
Range("I20") Then
ActiveChart.Axes(xlValue).CrossesAt.Value = Range("I20")
End If
I sure it something very simple and basic but I'm not sure what to do.
Thanks in advance
2.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?
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 cutoff 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 email for a sample copy of the workbook
Best regards,
markc
4.Can't get the xaxis to cross at value 0 for both yaxes
Hello 
I am working on an Excel chart with both a primary and secondary yaxis and
only one xaxis. The primary has positive and negative values. The
secondary has all positive values. I am using the secondary as a rank (by
selecting the box to invert values so the highest rank has a value of 1 and
appears at the top of the secondary yaxis, where rank 25 is the lowest
possible rank and appears at the bottom of the secondary yaxis), in theory
where the x and y axes meet. The xaxis is different points in time. So
this chart shows trends over time.
The issue I am having is the primary xaxis crosses the primary yaxis at 0
(yaxis value), which is what I want. However, the primary xaxis crosses
the secondary yaxis at a value that is not the lowest value on the secondary
yaxis. In this case, since I am using it as a rank, it is not crossing at
the lowest rank. I am not showing the secondary xaxis associated with rank.
I don't have this issue if all of the values on the primary yaxis are
positive. In other words, the primary xaxis crosses at 0 on the primary
yaxis and at the lowest rank on the secondary axis.
My question is, is there a way to fix my problem? Is there an option where
I can set the value where the primary xaxis crosses a value on the secondary
yaxis? I know I can set the value for Primary xaxis to primary yaxis 
and do the same for the secondary x and y axes, but I'm not aware of a way to
cross this primary  secondary boundary.
I imagine the graph's axes looking like a backwards 4  the primary yaxis
goes above and below the primary xaxis. The primary xaxis is approximately
in the middle. The secondary yaxis is as high as the primary yaxis but
only goes down to the xaxis (i.e., it does not extend below the xaxis). Is
this possible?
Something like this:
 
_______


Thanks!
 Derek
5.Xaxis to cross Yaxis at avrg Yvalue
Have been trying for ages to get the Xaxis to cross the Yaxis at exactly
the avrg Yvalue  to see results above and below average. But I can't find a
way to do it. Anyone?
(Tried recording a macro that takes the avrg value and pastes it into the
field in the "Value (X) axis crosses at" field, but it pastes the formula
rather than the number, and Excel can't handle a formula in that field...)
Thanks for any help
6. 2axis problem with horizontal crossing
7. How do I reference xaxis or yaxis scale values to a worksheet ce
8. why can't Yaxis cross the Xaxis at zero