Getting to Know the Parts of an Excel 2010 Chart

The typical chart (or graph) in Excel 2010 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 Choose the Right Chart Type in Excel 2010

When you display your data visually in Excel 2010, 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…]

Customizing the Type and Style of an Excel 2010 Chart

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

How to Add Titles to Excel 2010 Charts

You can add titles to an Excel 2010 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 [more…]

How to Add Data Labels to an Excel 2010 Chart

You can add data labels to an Excel 2010 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…]

Formatting Excel 2010 Chart Elements

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

How to Format the X-axis and Y-axis in Excel 2010 Charts

When charting values, Excel 2010 isn't always careful how it formats the values that appear on the y-axis (or the x-axis when using some chart types). If you're not happy with the way the values appear [more…]

How to Move and Resize an Embedded Excel 2010 Chart

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

How to Move an Embedded Excel 2010 Chart to Its Own Chart Sheet

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

How to Enhance a 3-D Chart in Excel 2010

Excel 2010 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 Edit a Chart's Data Source in Excel 2010

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

How to Print an Excel 2010 Chart

Printing a chart in Excel 2010 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…]