how can i make a climate graph
 

i am using excel 2007 and i need to know how to make a graph with two y axes
the bars being precepitaion and and the line being temperature. how will i do
this

how can i make a climate graph
 

Hi,

Create a standard clustered column chart based on both sets of data.
Select the Temperature series, right click and pick Change Series chart
type...
Select the line chart type.
Select the new line series and right click, pick Format Data Series. Select
Series Option, if not already active, and set secondary axis.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"spongebran" wrote in message
...
i am using excel 2007 and i need to know how to make a graph with two y
axes
the bars being precepitaion and and the line being temperature. how will i
do
this