I've been viewing the forum for Secondary axis in 2007. I imported a 2003 file with multiple series and do not see the right side axis. In 2003, under chart area/chart options/axes, you could add a secondary axis for value only. This allowed right side axis information that you would line up with the left side primary axis for viewing only.
I notice from the forum and playing with 2007, that this is no longer available and one must now plot a series to a secondary axis to be able to see a scale (either using a dummy series or a real one, then adjust the new axis to be the same as the primary)....How do we get this back.
My problem, is that when I select an existing series and re-plot on the secondary axis, the series compresses to the left side of the graph. The vertical looks fine, but the horizontal is shrunk. When I select the series, I see that the ranges in the series (in the formula bar) do extend to the full end of the graph (the same as other primary curves). Could there be something wrong with my series. I have also tried to delete and recreate the series (using the select data icon and adding a new series, then modify and plot on a secondary axis, ...same shrunk curve.
Does saving the file in the old format of Excel retain the old functions, or do you just loose some unsupported functions?
Bookmarks