Dummies.com - Making Everything Easier
Charts
View:
Sorted by:
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…]
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…]
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…]
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…]
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…]
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…]
Creating and Formatting a Pivot Chart in Excel 2007
After you create a pivot table in Excel 2007, you can create a pivot chart to display its summary values graphically. You also can format a pivot chart to improve its appearance. You can use any of the [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…]
Choosing the Right Chart Type in Excel 2007
When you display your data visually in Excel 2007, choosing the right type of chart is just as important as deciding to use a chart at all. Different charts display the data in very different ways. Using [more…]
Filtering an Excel 2007 Pivot Chart
Just as you can filter an Excel 2007 pivot table to display a subset of data, you also can use the PivotChart Filter pane to filter a pivot chart so that it shows just the information you want it to show [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…]
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…]
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…]
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…]
How to Add a Data Table to an Excel 2007 Chart
In Excel 2007, data tables display chart values in a grid beneath the chart. They are helpful if you need to see exact values along with a graphical display, such as when using a 3-D chart. Also, they [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…]
How to Move an Excel 2007 Pivot Chart to Its Own Sheet
Excel 2007 automatically displays new pivot charts on the same worksheet as the pivot table. However, if you move the pivot chart to its own sheet in the workbook, you may find it easier to customize and [more…]
Placing an Embedded Excel 2007 Chart onto Its Own Chart Sheet
Excel 2007 automatically embeds new charts on the same worksheet as the source data, but you may find it easier to work with a chart if you move the chart to its own chart sheet in the workbook. [more…]
Inside Dummies.com
WINDOWS 7 TIPS & TRICKS
|
EDUCATION & LANGUAGES
|
