Weather Chart

I am trying to construct a weather recording chart which will show maximum and minimum temperatures on a rage of 0 to 100, barometric pressure on a range of 28 to 31 and rainfall on a range of 0 to 2. I cannot find any information on how to do this. Using a single y axis scale results in the rainfall not showing and the barometric prssure as a virtualy straight lin.

Is this is possible using excel ?
If so how it is done?

If it is really complex could somebody just point me in the right dirrection as to where I can find the information I need.

David -

You could try this technique. Adjust it to make three different regions, one
with each scale, covering the ranges 0-1, 1-2, and 2-3; adjust the
corresponding data so 0-100 corresponds to 0-1, 23-31 corresponds to 1-2,
and 0-2 inches of rain corresponds to 2-3.

http://peltiertech.com/Excel/Charts/StackedCharts.html

The transformations are not too complicated. For temperature, just divide by
100. For pressure, subtract 23, divide by 8 (31 minus 23), then add 1. For
rainfall, divide by two and add 2. Construct three dummy axes as shown in
the example cited above, or using this technique:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

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


"David D" <David.D.1zizva_1133716801.8603@excelforum-nospam.com> wrote in
message news:David.D.1zizva_1133716801.8603@excelforum-nospam.com...
>
> I am trying to construct a weather recording chart which will show
> maximum and minimum temperatures on a rage of 0 to 100, barometric
> pressure on a range of 28 to 31 and rainfall on a range of 0 to 2. I
> cannot find any information on how to do this. Using a single y axis
> scale results in the rainfall not showing and the barometric prssure as
> a virtualy straight lin.
>
> Is this is possible using excel ?
> If so how it is done?
>
> If it is really complex could somebody just point me in the right
> dirrection as to where I can find the information I need.
>
>
> --
> David D
> ------------------------------------------------------------------------
> David D's Profile:
> http://www.excelforum.com/member.php...o&userid=29348
> View this thread: http://www.excelforum.com/showthread...hreadid=490569
>

Thanks for your help.

Looks like a couple of interesting hours work