Training Aid: Floating Charts

How to Float Your Boat While Floating Charts in Excel and PowerPoint

If you’re looking to create interest in your charts in Excel and PowerPoint, consider creating a floating chart. Floating charts are useful when you want data in a chart to depict minimum and maximum values. There is no floating column chart type in Excel or PowerPoint; however, using a Stacked Column chart that contains two (or more) data series, you can make some data series invisible so that you can portray a specific data series as a floating column chart.

To create a floating column chart:

1.       In Excel, select the chart data and from the Insert tab, click the Insert Column Chart options button and select 2-D or 3-D Stacked Column.

2.       In PowerPoint, on the slide, select the Insert Chart button and select Stacked Column or 3-D Stacked Column and enter the data (or copy and paste data from a worksheet) for the chart.

3.       To hide a data series in either application, select the data series and from the Format tab, click the Format Selection button.

4.       On the Format Data Series pane, click the Fill & Line button, expand the Fill options, and select No fill.

5.       To remove the lines, expand the Border options and select No line.

6.       Click the Close button to save the changes.

7.       Repeat for any additional data series.

Now that you’ve learned to float your chart, how about you float your boat? Traveling Coaches’ Certified Legal Trainer Program is the first and only program to focus on the new skills and best-practices law firm trainers must master in order to bring real value to their firms. Register for our webinar to find out how you can experience a range of adult learning, facilitation, engagement, measurement and organizational theories, filtered for relevance and effectiveness within a law firm, and delivered by award-winning educators.