### Similar Threads:

1.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

2.Display of secondary axis trendline for a secondary axis plot

I'm having trouble getting an Excel XP chart to display the trend line for a
plot related to the secondary axis. When I do so, it shows up on the legend
list, but not (observedly) on the graph itself.
If I change all to the primary axis, then I can get the problem line trended
- that is, I can see the trend line (but of little use at that scaling).

3.Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot

In Excel 2007, I have three columns of values. When I create a scatter chart
with these three columns, the first is the X axis data and I can show a Primary
Y axis for the second column data and a Secondary Y axis for the third column
data. But when I click on "Values in reverse order" on the X axis, only the
primary Y axis data plot is flipped, not the secondary axis data. Please test
this yourself and see what I mean. I can find no way to fix this problem.
Please let me know if you have a solution.

4.Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis

Even after googling for a while I cannot find anyone with the same
problem, so here it is:
if generating a Line Chart out of a Pivot Table with Page fields, AND
using a Secondary Y Axis in the line chart to separate 2 or more
curves, this secondary Y axis disappears as soon as any Page Field
value is reselected or changed!
I'd call this a serious bug.
Depending on the Excel versions I tried the effect is different, but
destructive to that Y2 association:
- in Excel 2002 (SP2) all curves of the Line Chart are associated with
the Primary Y axis, the secondary one disappears
- in Excel 2000 the LABELS of BOTH Y axes disappear (even worse as the
curves can no longer associated with each scale)
The only way to get the Secondary Y Axis back is to select any curve
and change "Axis" in the "Format Series" menu.
Is there any official fix for this or a work-around.
We generate these charts programmatically through VB/VBA and need it
work reliably.
Thanks
michael walter

5.Chart distorts secondary axis when the x-axis is logarithmic

I'm trying to create a chart whose x-axis and primary y-axis are logarithmic
and whose secondary y-axis is linear using Excel 2007. No matter how I build
the chart (i.e. three columns at the same time, or adding a series at a time)
as soon as I select logarithmic from the x-axis options the data plotted on
the y-axis ( the linear axis) becomes distorted (logarithmic). How can I
correct this? Thanks for your help.

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

7. How do I get the secondary axis to cross at zero

8. Secondary Axis not crossing at zero