Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
HI,
I'm trying to graph the growth of $10,000 of a Mutual fund vs. the benchmark. I'm working with montly returns over a period of 5 years. Can anyone help with the appropriate graph? Any help would be great. Thanks, Rachel |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In Cells A1:A60 enter your periods...Example: Jan 2006, Feb 2006, etc
in Cells B1:B60 enter your growth rate in Cells C1:C60 enter your benchmark Put your cursor on Cell A1 Select the Chart Wizard icon on the top command bar or Select InsertChart... and follow the Chart Wizard. HTH, -- Gary Brown If this post was helpful to you, please select 'YES' at the bottom of the post. "Rachel" wrote: HI, I'm trying to graph the growth of $10,000 of a Mutual fund vs. the benchmark. I'm working with montly returns over a period of 5 years. Can anyone help with the appropriate graph? Any help would be great. Thanks, Rachel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating growth with negative numbers | Excel Worksheet Functions | |||
growth rate but not average | Excel Discussion (Misc queries) | |||
Calculating Compounded Growth & the XIRR Function | Excel Discussion (Misc queries) | |||
monthly growth rate | Excel Worksheet Functions | |||
Growth | Excel Worksheet Functions |