Select Page

Excel Video 97 Modifying and Deleting Chart Ranges

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

Excel Video 96 Turn Chart Data On and Off

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

Excel Video 95 Check Boxes and Group Boxes

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