by Nate Moore | Oct 4, 2010 | Charts
Excel Video 98 shows an easy way to change the order your data is plotted in on a chart. Normally you’ll type data into Excel in the order you want it to appear on a chart. If you’re downloading data from your PM system or some other source, the data may not be in the...
by Nate Moore | Sep 29, 2010 | Charts
Excel Video 97 is a break from some of the complicated OFFSET examples we’ve been working through. Today I want to show you one tip when you’re charting years and then three ways to modify and/or delete the data in your chart. The tip applies when you have a chart...
by Nate Moore | Sep 27, 2010 | Charts
Excel Video 96 picks up where we left off in Excel Video 95. First, notice how changing the background color of the check boxes makes the chart look better and allows us to remove the legend, which makes the plot area bigger. It’s also helpful to remove the legend...
by Nate Moore | Sep 22, 2010 | Charts
Excel Video 95 demonstrates how to use check boxes inside a group box to allow users to choose which data to show on a chart. Our sample data is established patient E&M codes for four physicians and the chart shows the relative percentages of each of the five...
by Nate Moore | Sep 20, 2010 | Charts
Excel Video 94 continues our discussion of whiz-bang ways to update your chart ranges. Last time we added a scroll bar to control the chart range. Today, we’ll try spin buttons. Spin buttons are simply an up arrow paired with a down arrow that we’ll use to change the...
by Nate Moore | Sep 15, 2010 | Charts
Excel Video 93 gets even fancier by adding a scroll bar right above the chart that automatically controls the number of columns in the chart. To get the scroll bar and other tools, you need to add the Developer tab to your ribbon. I’ll show you how to add that, and...
