Is it possible to show a graph where the changes over a predetermined period of time can be shown? For example plot the returns for the 1st quarter, and after a few seconds the plot for the second quarter are also shown, then the 1st quarter plot data fades out? You could adapt this to all sorts of situations if its possible?
Hi Ted,
I think you're looking for a sort of animation:
See this topic for a similar solution: https://www.myonlinetraininghub.com/excel-forum/vba-macros/animating-a-chart-over-time
Thank you for your reply. Unfortunately I am unable to open either the xls file you initially posted nor the second one. They open up like 10 Shakespearean plays all overlaid on one another. In thinking about this issue raised in the thread,I'm guessing I may need to show the plotted data for a period of time then show the second set of data. Would it be possible to overlay both plots and have the Firestone simply fade out?,
Wonder why you cannot download the sample files, what happens?
Anything can be done, you can overlap the 2 charts, they play with transparency of the top one until it is completely hidden.
