Formatting

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…]

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…]

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…]

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…]