| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I make a graph to be a specific size? (actual graph) | Excel Discussion (Misc queries) | |||
| how do i make an xy graph start at 0 instead of at 1? | Charts and Charting in Excel | |||
| How do I make a Bar Graph? | Charts and Charting in Excel | |||
| How do I make a graph? | New Users to Excel | |||
| Trying to make a log-log graph | Excel Discussion (Misc queries) | |||
Linear Mode
