by Nate Moore | Feb 28, 2011 | Charts
Excel Video 135 is an easier video than Excel Video 134. Today we’re simply going to set up the charts we need for the scrolling data. Since I want the charts to have similar formatting, I set up the bottom chart first and get it close to what I want. Once I’m most of...
by Nate Moore | Feb 23, 2011 | Charts
Excel Video 134 covers two tricks I used to make the scrolling chart work, a formatting trick and a formula. The formatting trick is easy once you know how custom formatting works. Follow along with the video to see how to get into the custom format screen and then...
by Nate Moore | Feb 21, 2011 | Charts
Excel Video 133 spotlights one more cool chart before we move on to other Excel topics. Credit for this idea goes to Bill Jelen and his Charts and Graphs for Microsoft Excel 2010 book. In this video I’ll give you an idea of how a scrolling chart works. In coming Excel...
by Nate Moore | Feb 16, 2011 | Charts
Excel Video 132 continues our discussion about getting charts onto dashboards. In the last Excel Video, we moved a chart onto the dashboard. You may choose instead to copy and paste the chart onto the dashboard. The pasted chart is still linked to live data, but now...
by Nate Moore | Feb 14, 2011 | Charts
Excel Video 131 contrasts two ways to get your charts onto a dashboard. The Move Chart button does just that, it moves your chart either onto a separate chart page or as an object in a spreadsheet. When you move a chart, the chart is still attached to your data. As...
