Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

The Essentials of Working with Charts in Excel 2007

The essentials of creating and working with charts in Excel 2007 will show you everything you need to know to convert your numbers into charts that can help your audience understand the meaning behind the data and make that data stand out.

Getting to Know the Parts of an Excel 2007 Chart

The typical chart (or graph) in Excel 2007 comprises several distinct parts, including the chart area, data series, axes, legend, plot area, gridlines, data markers, and more. The following list summarizes [more…]

Customizing the Type and Style of an Excel 2007 Chart

When you add a chart to an Excel 2007 workbook, a new Chart Tools Design tab appears in the Ribbon. You can use the command buttons on the Chart Tools Design tab to customize the chart type and style. [more…]

Editing a Chart’s Data Source in Excel 2007

After you create a chart in Excel 2007, you may need to change the range of the source data that is the basis for the chart. The Select Data Source dialog box lets you choose a different source range for [more…]

Changing Chart Elements in Excel 2007

The command buttons on the Chart Tools Layout tab in Excel 2007 make it easy to change or customize particular parts of your chart. This customization includes buttons in the following groups on the Layout [more…]

Formatting Excel 2007 Chart Elements

The Chart Tools Format tab in Excel 2007 contains command buttons that make it easy to format chart elements you select. Excel gives you a choice of methods for selecting individual chart elements: [more…]

How to Add Titles to Excel 2007 Charts

You can add titles to a chart to help describe its purpose. By default, titles are not added when you create a basic chart, but you can add them later manually. In addition to a main chart title that is [more…]

Formatting Chart Titles in Excel 2007

When you add chart titles, Excel 2007 uses the Calibri (Body) font for the chart title (in 18-point size) and the x- and y-axis (in 10-point size). To change the font used in a title, or to change any [more…]

Formatting the X-axis and Y-axis in Excel 2007 Charts

When charting values, Excel 2007 isn’t always careful how it formats the values that appear on the y-axis (or the x-axis when using some chart types, such as the 3-D Column chart or the XY Scatter chart [more…]

How to Add Data Labels to a Chart in Excel 2007

You can add data labels to an Excel 2007 chart to help identify the values shown in each data point of the data series. Excel provides several options for the placement and formatting of data labels. [more…]

Enhancing a 3-D Chart in Excel 2007

Excel 2007 includes several options for enhancing 3-D charts, such as changing the rotation and perspective and using 3-D options that format the chart border. These and other related options can be found [more…]

Moving and Resizing an Embedded Excel 2007 Chart

After you create a new chart in an Excel 2007 worksheet, you can easily move or resize the embedded chart. Whenever an embedded chart is selected (as it is automatically immediately after creating it or [more…]

Printing an Excel 2007 Chart

Printing a chart in Excel 2007 is a breeze, but the method you choose for printing the chart depends on whether you want to print an embedded chart (with or without the surrounding worksheet data) or a [more…]

blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!