Wiley 978-0-470-04400-1 Datasheet

Chapter Introducing Excel ChartsIn This Chapter◆ What is a chart?◆ How Excel handles charts◆ Embedded charts versus chart sheets◆ The parts of a chart

Figure 1-7: A 3-D column chartPart I: Chart Basics18The following table lists the limitations of Excel charts.Item LimitationCharts in a worksheet Lim

Basic Steps for Creating a ChartThe previous version of Excel featured a Chart Wizard that guided the user through thesteps required in creating a cha

Figure 1-9: The icons in the Insert➪Charts group expand to show a gallery of chart subtypes.Figure 1-10: A column chart with two data seriesSwitching

Chart Tools➪Design➪Data➪Switch Row/Column. This command is a toggle, so if changingthe data orientation doesn’t improve the chart, just choose the com

Figure 1-12: The Change Chart Type dialog boxTIPIf the chart is an embedded chart, you can also change a chart’s type by using the iconsin the Insert➪

Figure 1-13: One-click design variations of a column chartTIPThe styles displayed in the gallery depend on the workbook’s theme. When you choosePage L

Figure 1-14 shows our column chart after adding a title and specifying that the legendshould appear at the bottom of the chart (using Chart Tools➪Layo

Excel provides two ways to format and customize individual chart elements. Both of thefollowing methods require that you select the chart element firs

Working with ChartsThe following sections cover these common chart modifications:•Moving and resizing a chart•Converting an embedded chart to a chart

Home➪Clipboard➪Paste (or press Ctrl+V). The new location can be in a different work-sheet or even in a different workbook. If you paste the chart to a

NOTEIn the first edition of this book, I offered an apology for the relatively poor visual qualityof Excel charts. I’m pleased to be able to retract t

Deleting a ChartTo delete an embedded chart, press Ctrl and click the chart (this selects the chart as anobject). Then press Delete. When the Shift ke

The Format command displays a stay-on-top tabbed dialog box, with options for theselected element.Figure 1-17 shows the Format Axis dialog box, which

Copying a Chart’s FormattingIf you create a nicely formatted chart, and realize that you need to create several morecharts that have the same formatti

TIPIf you select an embedded chart and choose Office➪Print, Excel prints the chart on apage by itself (as if it were a chart sheet) and does not print

Part I: Chart Basics3205_044001 ch01.qxp 8/24/07 8:48 PM Page 32

a chart resides in a single worksheet, but that’s not a strict requirement. As you’ll see, achart can use data that’s stored in any number of workshee

Embedded ChartsAn embedded chart basically floats on top of a worksheet, on the worksheet’s drawing layer.The charts shown previously in this chapter

Chart SheetsYou can move an embedded chart to its own chart sheet, so you can view it by clicking asheet tab. When you move a chart to a chart sheet,

Part I: Chart Basics14In Microsoft Office 2007, the charting feature has undergone some major changes. Ifyou’ve used the charting feature in a previou

Chapter 1: Introducing Excel ChartsPart I15• Rotating 3-D charts: In previous versions, you could use your mouse to directlymanipulate the view of a 3

Parts of a ChartA chart is made up of many different elements, and all of these elements are optional. Yes,you can create a chart that contains no cha

If a chart has more than one data series, you’ll usually need a way to identify the data seriesor data points. A legend, for example, is often used to