software

How do you space the primary and secondary axis equally. I've been fooling
around with quot;Format Data Seriesgt;Optionsquot;, but I can't get them equally spaced
and with the same size. Is there something I'm missing or is Excel 2000 just
trying to intimidate me???? Connie

What to you mean by 'equally spaced'
Same range (Max1=max2, Min1=Min2) ?
Same interval between gridline?
Tell us more
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from emailquot;Connie Martinquot; gt; wrote in message
...
gt; How do you space the primary and secondary axis equally. I've been
gt; fooling
gt; around with quot;Format Data Seriesgt;Optionsquot;, but I can't get them equally
gt; spaced
gt; and with the same size. Is there something I'm missing or is Excel 2000
gt; just
gt; trying to intimidate me???? Connie
Bernard,

I'm trying to do something similar. Let me explain.

I would like the 100% point of the secondary axis match the maximum value on
the secondary axis. Let me give you an example.

I have a chart where the maximum plotted value for the primary axis is 9840.
The chart automatically sets the maximum for the primary axis to 12000.
I'd like the maximum for the secondary axis to be

12000/9840 = 1.22 ...

I suspect I'll need to do this programmatically.

I nave a named range of quot;TotalRequirementsquot; and I need to get the maximum
value from that and set an upper level for the primary and secondary axis
based on that value.

How do I do this without any involvement by the user?

Thanks in advance,
Barb Reinhardt

quot;Bernard Liengmequot; wrote:

gt; What to you mean by 'equally spaced'
gt; Same range (Max1=max2, Min1=Min2) ?
gt; Same interval between gridline?
gt; Tell us more
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt;
gt; quot;Connie Martinquot; gt; wrote in message
gt; ...
gt; gt; How do you space the primary and secondary axis equally. I've been
gt; gt; fooling
gt; gt; around with quot;Format Data Seriesgt;Optionsquot;, but I can't get them equally
gt; gt; spaced
gt; gt; and with the same size. Is there something I'm missing or is Excel 2000
gt; gt; just
gt; gt; trying to intimidate me???? Connie
gt;
gt;
gt;

Since XL will not let one link the scale parameters to cells (or named
formulas), you have to do this programmatically.

For a readymade solution see
AutoChart Manager
www.tushar-mehta.com/excel/so...art/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article gt;,says...
gt; Bernard,
gt;
gt; I'm trying to do something similar. Let me explain.
gt;
gt; I would like the 100% point of the secondary axis match the maximum value on
gt; the secondary axis. Let me give you an example.
gt;
gt; I have a chart where the maximum plotted value for the primary axis is 9840.
gt; The chart automatically sets the maximum for the primary axis to 12000.
gt; I'd like the maximum for the secondary axis to be
gt;
gt; 12000/9840 = 1.22 ...
gt;
gt; I suspect I'll need to do this programmatically.
gt;
gt; I nave a named range of quot;TotalRequirementsquot; and I need to get the maximum
gt; value from that and set an upper level for the primary and secondary axis
gt; based on that value.
gt;
gt; How do I do this without any involvement by the user?
gt;
gt; Thanks in advance,
gt; Barb Reinhardt
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt; gt; What to you mean by 'equally spaced'
gt; gt; Same range (Max1=max2, Min1=Min2) ?
gt; gt; Same interval between gridline?
gt; gt; Tell us more
gt; gt; --
gt; gt; Bernard V Liengme
gt; gt; www.stfx.ca/people/bliengme
gt; gt; remove caps from email
gt; gt;
gt; gt;
gt; gt; quot;Connie Martinquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; How do you space the primary and secondary axis equally. I've been
gt; gt; gt; fooling
gt; gt; gt; around with quot;Format Data Seriesgt;Optionsquot;, but I can't get them equally
gt; gt; gt; spaced
gt; gt; gt; and with the same size. Is there something I'm missing or is Excel 2000
gt; gt; gt; just
gt; gt; gt; trying to intimidate me???? Connie
gt; gt;
gt; gt;
gt; gt;
gt;