Log In
Register
Home
Xtreme Pivot Tables
December 20, 2021
Offline
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?
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Ted,
I think you're looking for a sort of animation:
See this topic for a similar solution: https://www.myonlinetraininghu.....-over-time
Xtreme Pivot Tables
December 20, 2021
Offline
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?,
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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.
1 Guest(s)
