Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel graphs
Using a line graph i would like to show on one chart two data series
with differing ranges. For example sereis one would be the unemployment rate in the US from 1998 to 2008 and series two would be the ending value of the S&P500 from 1998 to 2008. Obviously the unemployment rate will be in percentages from 3% to 7% and the ending S&P500 values would be whole numbers ranging from 800 or so to 1400 and back down to 800. The reason i want to do this is to show the relationship between the unemployment rate and the stock market. Is this possible to do on one chart and is it possible in excel? Thanks Howard |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel graphs
u may do it in several ways, the easiest one for two data series with very
different scaling (absolute and relative) is to use primary y-axis for first series and secondary y-axis (riht-hand axis) for second series. Just right click on particular series and choose format, then find where to redirect y-axis (the way is slightly different in Excel2007 vs. 2003) " wrote: Using a line graph i would like to show on one chart two data series with differing ranges. For example sereis one would be the unemployment rate in the US from 1998 to 2008 and series two would be the ending value of the S&P500 from 1998 to 2008. Obviously the unemployment rate will be in percentages from 3% to 7% and the ending S&P500 values would be whole numbers ranging from 800 or so to 1400 and back down to 800. The reason i want to do this is to show the relationship between the unemployment rate and the stock market. Is this possible to do on one chart and is it possible in excel? Thanks Howard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel graphs
On Feb 4, 7:05*pm, Alojz wrote:
u may do it in several ways, the easiest one for two data series with very different scaling (absolute and relative) is to use primary y-axis for first series and secondary y-axis (riht-hand axis) for second series. Just right click on particular series and choose format, then find where to redirect y-axis (the way is slightly different in Excel2007 vs. 2003) " wrote: Using a line graph i would like to show on one chart two data series with differing ranges. For example sereis one would be the unemployment rate in the US from 1998 to 2008 and series two would be the ending value of the S&P500 from 1998 to 2008. Obviously the unemployment rate will be in percentages from 3% to 7% and the ending S&P500 values would be whole numbers ranging from 800 or so to 1400 and back down to 800. The reason i want to do this is to show the relationship between the unemployment rate and the stock market. Is this possible to do on one chart and is it possible in excel? Thanks Howard- Hide quoted text - - Show quoted text - That worked - thank you so much. Howard |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel graphs
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel graphs
welcome, glad to help
" wrote: On Feb 4, 7:05 pm, Alojz wrote: u may do it in several ways, the easiest one for two data series with very different scaling (absolute and relative) is to use primary y-axis for first series and secondary y-axis (riht-hand axis) for second series. Just right click on particular series and choose format, then find where to redirect y-axis (the way is slightly different in Excel2007 vs. 2003) " wrote: Using a line graph i would like to show on one chart two data series with differing ranges. For example sereis one would be the unemployment rate in the US from 1998 to 2008 and series two would be the ending value of the S&P500 from 1998 to 2008. Obviously the unemployment rate will be in percentages from 3% to 7% and the ending S&P500 values would be whole numbers ranging from 800 or so to 1400 and back down to 800. The reason i want to do this is to show the relationship between the unemployment rate and the stock market. Is this possible to do on one chart and is it possible in excel? Thanks Howard- Hide quoted text - - Show quoted text - That worked - thank you so much. Howard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel graphs | Excel Discussion (Misc queries) | |||
graphs in excel | Excel Discussion (Misc queries) | |||
Excel Graphs | Excel Discussion (Misc queries) | |||
Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
Automatic Graphs/ Dynamic Graphs | Charts and Charting in Excel |