Excel 2010 Charts

Sorted by:  

How to Create and Format a Pivot Chart in Excel 2010

After you create a pivot table in Excel 2010, 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…]

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 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 Add a Data Table to an Excel 2010 Chart

In Excel 2010, data tables display the 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…]

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

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 Show Trends Visually with Excel 2010's Sparklines

Excel 2010 introduced sparklines, a new type of information graphic that represents trends or variations in collected worksheet data. Sparklines are tiny graphs [more…]

How to Filter an Excel 2010 Pivot Chart

Just as you can filter an Excel 2010 pivot table to display a subset of data, you also can filter a pivot chart so that it shows just the information you want it to show. When you graph the data in an [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 Compare Excel 2010 Values with Sparklines

Excel's charts can help you visualize data, but sometimes, creating a massive chart with legends, titles, and axes can seem like too much trouble. Excel 2010 offers a simpler tool called sparklines. Sparklines [more…]

How to Edit and Format an Excel 2010 Chart

Creating a chart in Excel 2010 can be helpful when trying to analyze a set of data. After you've created a chart in Excel, modifying it to make it look better, to match a color scheme, or even to chart [more…]
Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software
Win $500. Enter Now.

Inside Dummies.com