software

Hi All,

I'm looking to plot data on primary and secondary axes, sometimes the data
is of different types, ie. sales $ and quantity.

When however, the data is of like type ie. sales $ and profit $, I'd like to
two axesto be synchronised so that they are effectively one axis, with a
minimum and maximum common for both primary and secondary axes.

When data reverts to being of different types, I'd like the axes to revert
back to independently auto.

Any ideas ?

VB is fine.

Thanks,

Neil
I am not sure what you expect in response. You've described what you
want to do. So, why not do it? If you expect software to figure out
when the quot;typesquot; of the two charts differ, you might be disappointed.

Of course, when the types are the same, you might simply want to use a
single axis. If the two are the same min. and max. value, there isn't
much point in having the 2nd axis, is there?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article gt;, says...
gt; Hi All,
gt;
gt; I'm looking to plot data on primary and secondary axes, sometimes the data
gt; is of different types, ie. sales $ and quantity.
gt;
gt; When however, the data is of like type ie. sales $ and profit $, I'd like to
gt; two axesto be synchronised so that they are effectively one axis, with a
gt; minimum and maximum common for both primary and secondary axes.
gt;
gt; When data reverts to being of different types, I'd like the axes to revert
gt; back to independently auto.
gt;
gt; Any ideas ?
gt;
gt; VB is fine.
gt;
gt; Thanks,
gt;
gt; Neil
gt;
gt;
gt;

Thanks Tushar,

Maybe some more detail is in order:

I am able to select from 7 sets of data for each axes.

I have setup a 'typematch' cell to capture whether the two data types being
displayed are matching (true or false).

Each time I reselect new data to plot, I want excel to check the 'typematch'
cell for true or false and hence
either match up the two y axes for min amp; max or leave them be.

Hence my inference to visual basic in the original post.

I'm quite ok to do this manually obviously but prefer this to occur
automatically.

Regards,

Neilquot;Tushar Mehtaquot; lt;tm_200310@tushar_hyphen_mehta_dot_see_oh_emgt; wrote in
message om...
gt;I am not sure what you expect in response. You've described what you
gt; want to do. So, why not do it? If you expect software to figure out
gt; when the quot;typesquot; of the two charts differ, you might be disappointed.
gt;
gt; Of course, when the types are the same, you might simply want to use a
gt; single axis. If the two are the same min. and max. value, there isn't
gt; much point in having the 2nd axis, is there?
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Multi-disciplinary business expertise
gt; Technology skills
gt; = Optimal solution to your business problem
gt; Recipient Microsoft MVP award 2000-2005
gt;
gt; In article gt;, says...
gt;gt; Hi All,
gt;gt;
gt;gt; I'm looking to plot data on primary and secondary axes, sometimes the
gt;gt; data
gt;gt; is of different types, ie. sales $ and quantity.
gt;gt;
gt;gt; When however, the data is of like type ie. sales $ and profit $, I'd like
gt;gt; to
gt;gt; two axesto be synchronised so that they are effectively one axis, with a
gt;gt; minimum and maximum common for both primary and secondary axes.
gt;gt;
gt;gt; When data reverts to being of different types, I'd like the axes to
gt;gt; revert
gt;gt; back to independently auto.
gt;gt;
gt;gt; Any ideas ?
gt;gt;
gt;gt; VB is fine.
gt;gt;
gt;gt; Thanks,
gt;gt;
gt;gt; Neil
gt;gt;
gt;gt;
gt;gt;