The fix is actually quite simple, if you have a Chart that’s a representation of either your existing Sheet or from a different Sheet of the same document you can move the ONLY the chart to a separate window while maintaining the link and data integrity between the data and the chart. It would ideal if there is a way to have the Charts open side by side with the original data so the visualization can occur in real time while data manipulation is being applied. However, the downside with a full sheet of charts is the consistent back and forth editing between the data and the charts. The issue that I ran into with my setup is the Chart that requires a large screen real estate, so it has to occupy the full sheet. Charts are a great way to visualize data and how data manipulation might have an affect on the overall picture. Here is a trick for those of you working with Excel on a daily basis, especially if you are spending a significant amount of time with charts.
0 kommentar(er)
