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...
by Nate Moore | Feb 9, 2011 | Charts
Excel Video 130 is much simpler than the last Excel Video. Now that we’ve used the frequency function to calculate the frequency of our data, here’s a trick to make your column chart look more like frequency than discrete data. The trick is to right-click the data...
by Nate Moore | Feb 7, 2011 | Charts
Excel Video 129 uses the frequency function to group data into ranges or buckets. Frequency is an array function. If you haven’t seen arrays, they work differently than traditional Excel functions. To tell Excel you’re entering an array formula, you need to hit...
