Weather Chart

[David D]

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.

 

[duane]

you could put the rainfall and bar pressure on a 2nd y axis - contruct
the chart, select the series and switch to 2nd y axis.

 

[Jon Peltier]

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]

Thanks for your help.

Looks like a couple of interesting hours work