Hey All - thanks for your responses upfront - this community rocks and has helped me out of a few pickles in the past so again - Thanks!
My question this time seems like it should be simple but I cannot figure it out. In Excel I have created a series of tabs reporting on different data points, etc. Now I want to copy those charts into a 'dashboard' tab where all the charts would be visible so the higher ups can see it all in one spot instead of clicking through each tab. My question is this - how to do it so that the chart is linked to the original so when I make changes in the data tab that it shows up in the dashboard tab? When working in that tab, whenever you make changes it updates automatically to the chart you created. However on my dashboard tab, the charts stay the same from when I copied/pasted them in the first time. Is there a way to make them linked or will I need to re-copy/paste in the new chart whenever I work on them?
My question this time seems like it should be simple but I cannot figure it out. In Excel I have created a series of tabs reporting on different data points, etc. Now I want to copy those charts into a 'dashboard' tab where all the charts would be visible so the higher ups can see it all in one spot instead of clicking through each tab. My question is this - how to do it so that the chart is linked to the original so when I make changes in the data tab that it shows up in the dashboard tab? When working in that tab, whenever you make changes it updates automatically to the chart you created. However on my dashboard tab, the charts stay the same from when I copied/pasted them in the first time. Is there a way to make them linked or will I need to re-copy/paste in the new chart whenever I work on them?