Originally Posted by
Sunnyskies
Timely subject. I have a spreadsheet which has the daily share prices for each fund. In separate sheets, I created a graph which plots the daily prices (separate sheet/graph for each fund). Each day I update the daily share prices (I insert the new data on line 2 which forces all the other data down a line). When the other data is forced down a line, the source data references for the graphs change also. I have to right click in each graph and update the "source data" so that it will include the new data (line 2 on my original spreadsheet). I have tried to remove the absolute references in the source data box, but the absolutes return everytime.
I suppose I could record a macro to automate the process, but sometimes those things mess me up. Any ideas to make the graphs automatically update when I insert new data?
Also, I change the color of the data point to reflect it I bought (green) or sold (red). Is there a way to indicate this on the data spreadsheet and have the graph plot that color automatically. What I found is that if I cause the graph to replot itself, then I lose the colors that I had put in. Hope this makes sense.
Bookmarks