One of the helpful guys on here programmed a spreadsheet for me. Unfortunately on the 3rd worksheet, I cannot get the benchmark yellow and purple lines to correctly draw up to March 2010 (the same length of time as the fund cumulative graph).
The data for the benchmark indicies are in tab 2. The dynamic cell referencing should automatically draw the chart based on the monthly data range for the fund (in worksheet 1).
Can someone please fix this for me such that the dynamic ranges still remain?