software

I am an engineer and am constantly ploting data in both metric and english
units on the same plot. I would like a way to show multiple scales on both
the y and x axis. Example: A series of data could have values of psi, bar, amp;
kPa for the y-axis, and ft^3 amp; meters^3 for the x-axis all on the same chart.
The chart could be a custom style and it could either prompt you for the
column or row the data in other units is in, or it could prompt you for the
scaling factor to multiply the x data by to get to the other units.
Currently, with Excel 2003, I make an XY scatter chart with two series, put
series 2 on the secondary x and Y axis, and manually set the axis scale
values so that the two series lay directly on top of each other, and turn off
the line on one and the points on the other.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...excel.charting

Hi:
I think you can only plot on two axes using the secondary axis as a dummy
axis, like you described. The only way I see to make more axes is by using
overlay charts, but this is pretty elaborative. Maybe the experts have a
more clever way.

Ok, to create an overlay chart, assuming you want a second x-axis under your
normal one, copy the chart, set in this copy what you don't need either to
Transparent, remove or make white (the right choice depends on whether the
plot area or scales adjust if you for instance remove them; if you remove the
data series the chart will be deleted so you need to make this transparant or
colour it as your background colour). Effectively you only keep the axis on
the scale of your choice (so a very empty chart!). Make the plot area a bit
longer (in case of a second x-axis) Now position the quot;chartquot; (now effectively
reduced to a floating x-axis) over the original and because it is transparent
the original chart now shows a second x-axis. You may have to trial a bit to
get the desired effect and to line your scale. Of course you can add more
overlays for more axes .... but, hey, this is already complicated enough!

I hope the description is not too complex. The main trick is to keep the
original dimensions and set properties to Transparent. I use this quot;trickquot; to
e.g. add gridlines on top of Area charts, or to let gridlines run in front of
columns.

I hope this suggestion is useful.
GL,
Henk
(NB: Keep lt;Altgt; pressed when dragging a chart with the mouse for more
accurate positioning)

quot;ACcompressorquot; wrote:

gt; I am an engineer and am constantly ploting data in both metric and english
gt; units on the same plot. I would like a way to show multiple scales on both
gt; the y and x axis. Example: A series of data could have values of psi, bar, amp;
gt; kPa for the y-axis, and ft^3 amp; meters^3 for the x-axis all on the same chart.
gt; The chart could be a custom style and it could either prompt you for the
gt; column or row the data in other units is in, or it could prompt you for the
gt; scaling factor to multiply the x data by to get to the other units.
gt; Currently, with Excel 2003, I make an XY scatter chart with two series, put
gt; series 2 on the secondary x and Y axis, and manually set the axis scale
gt; values so that the two series lay directly on top of each other, and turn off
gt; the line on one and the points on the other.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...excel.charting

It's easier than using overlays. You can use as many dummy series in your
chart (up to 255 or 256 series per chart). Set up one as a secondary axis,
with the appropriate labels. Here are some sample charts with pseudoaxes:

peltiertech.com/Excel/Charts/...tml#AxisScales

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;HEKquot; gt; wrote in message
...
gt; Hi:
gt; I think you can only plot on two axes using the secondary axis as a dummy
gt; axis, like you described. The only way I see to make more axes is by
gt; using
gt; overlay charts, but this is pretty elaborative. Maybe the experts have a
gt; more clever way.
gt;
gt; Ok, to create an overlay chart, assuming you want a second x-axis under
gt; your
gt; normal one, copy the chart, set in this copy what you don't need either to
gt; Transparent, remove or make white (the right choice depends on whether the
gt; plot area or scales adjust if you for instance remove them; if you remove
gt; the
gt; data series the chart will be deleted so you need to make this transparant
gt; or
gt; colour it as your background colour). Effectively you only keep the axis
gt; on
gt; the scale of your choice (so a very empty chart!). Make the plot area a
gt; bit
gt; longer (in case of a second x-axis) Now position the quot;chartquot; (now
gt; effectively
gt; reduced to a floating x-axis) over the original and because it is
gt; transparent
gt; the original chart now shows a second x-axis. You may have to trial a bit
gt; to
gt; get the desired effect and to line your scale. Of course you can add more
gt; overlays for more axes .... but, hey, this is already complicated enough!
gt;
gt; I hope the description is not too complex. The main trick is to keep the
gt; original dimensions and set properties to Transparent. I use this quot;trickquot;
gt; to
gt; e.g. add gridlines on top of Area charts, or to let gridlines run in front
gt; of
gt; columns.
gt;
gt; I hope this suggestion is useful.
gt; GL,
gt; Henk
gt; (NB: Keep lt;Altgt; pressed when dragging a chart with the mouse for more
gt; accurate positioning)
gt;
gt; quot;ACcompressorquot; wrote:
gt;
gt;gt; I am an engineer and am constantly ploting data in both metric and
gt;gt; english
gt;gt; units on the same plot. I would like a way to show multiple scales on
gt;gt; both
gt;gt; the y and x axis. Example: A series of data could have values of psi,
gt;gt; bar, amp;
gt;gt; kPa for the y-axis, and ft^3 amp; meters^3 for the x-axis all on the same
gt;gt; chart.
gt;gt; The chart could be a custom style and it could either prompt you for the
gt;gt; column or row the data in other units is in, or it could prompt you for
gt;gt; the
gt;gt; scaling factor to multiply the x data by to get to the other units.
gt;gt; Currently, with Excel 2003, I make an XY scatter chart with two series,
gt;gt; put
gt;gt; series 2 on the secondary x and Y axis, and manually set the axis scale
gt;gt; values so that the two series lay directly on top of each other, and turn
gt;gt; off
gt;gt; the line on one and the points on the other.
gt;gt;
gt;gt; ----------------
gt;gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt;gt; suggestions with the most votes. To vote for this suggestion, click the
gt;gt; quot;I
gt;gt; Agreequot; button in the message pane. If you do not see the button, follow
gt;gt; this
gt;gt; link to open the suggestion in the Microsoft Web-based Newsreader and
gt;gt; then
gt;gt; click quot;I Agreequot; in the message pane.
gt;gt;
gt;gt; www.microsoft.com/office/comm...excel.charting