Business Solutions Tricks of the Microsoft Office 2007 Gurus

8. Chart Tricks

IN THIS CHAPTER

Using Worksheet Text in a Chart

Plotting the Average on the Value Axis

Stacking a Picture as a Bar Chart Data Marker

Charting a Dynamic Range

Automatically Expanding a Chart to Include New Data

Displaying a Second Vertical Axis

Exploding a Slice from a Pie Chart

Charting Small Values with a Bar of Pie Chart

Creating a Scrolling Chart

Plotting a Best-Fit Trendline

Plotting Forecasted Values

One of the best ways to analyze your worksheet data—or get your point across to other people—is to display your data visually in a chart. Excel gives you tremendous flexibility when you create charts; it enables you to place charts in separate documents or directly on the worksheet itself. Not only that, but you have dozens ...