Hi.
I apologise for asking this question, this is something I should know but I can't seem to get it working.
I have two columns: date, fund value starting from D6:E6 downwards. I will be adding the data every know and then and want to base a line graph on it.
I don't know what to put as a reference in the chart wizard, I suspect it's something alone the lines of OFFSET(D6,0,0,count(d:d),1). Also what forumla would you put so that the x axis contains the dates.
thanks,
RET79
I apologise for asking this question, this is something I should know but I can't seem to get it working.
I have two columns: date, fund value starting from D6:E6 downwards. I will be adding the data every know and then and want to base a line graph on it.
I don't know what to put as a reference in the chart wizard, I suspect it's something alone the lines of OFFSET(D6,0,0,count(d:d),1). Also what forumla would you put so that the x axis contains the dates.
thanks,
RET79