Select Page

Excel Video 135 Creating the Scrolling 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...

Excel Video 134 Prepare the Scrolling Chart Data

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...

Excel Video 133 Scrolling Chart Overview

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...

Excel Video 132 Copying Charts into Dashboards

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...

Excel Video 131 Moving Charts vs Camera

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...