I routinely make graphs for many different product lines, and am
constantly altering the secondary axis min/max/ or scale so the graph
doesn't look odd.  Is there a way to automatically have the secondary
axis min/max/ or scale values change so that the secondary axis major
tick marks will line up with those of the primary axis?

For example, in the following data series, automatically makes the
primary axis range from 0 to 14000, with a 2000 unit increment.  On the
secondary axis, excel sets it to 0 to 250 with a 50 point increment.
How do I trick excel into make the secondary axis have 7 increments
(14000 / 2000) so that the major tick marks / gridlines match one
another?  (eg 7 * 50 = a 350 secondary axis max value, which makes the
gridlines work).

Point    Primary    Secondary
1    1000    10
2    2000    20
3    3000    30
4    4000    100
5    5000    50
6    6000    60
7    7000    70
8    8000    200
9    12000    200
10    8000    200

Thoughts?
Brian