Excel 2013 Charts

View:  
Sorted by:  

How to Create Charts From the Ribbon in Excel 2013

To the right of the Recommended Charts button in the Charts group of the Ribbon’s Insert tab in Excel 2013, you find particular command buttons with drop-down galleries for creating the following types [more…]

How to Move and Resize Embedded Charts in Excel 2013

Right after you create a new embedded chart in a worksheet in Excel 2013, you can easily move or resize the chart because the chart is still selected. You can always tell when an embedded chart is selected [more…]

How to Customize Charts from the Design Tab in Excel 2013

In Excel 2013, you can use the command buttons on the Design tab of the Chart Tools contextual tab to make all kinds of changes to your new chart. The Design tab contains the following groups of buttons [more…]

How to Customize Chart Elements in Excel 2013

The Chart Elements button (with the plus sign icon) that appears when your chart is selected in Excel 2013 contains a list of the major chart elements that you can add to your chart. To add an element [more…]

How to Edit and Format Chart Titles in Excel 2013

When Excel 2013 first adds titles to a new chart, it gives them generic names, such as Chart Title and Axis Title. To edit or format these generic titles with the actual chart titles, click the title in [more…]

How to Add and Format Text Boxes in a Chart in Excel 2013

To add a text box in Excel 2013 like the one shown to the chart when a chart is selected, select the Format tab under the Chart Tools contextual tab. Then, click the Insert Shapes drop-down button to open [more…]

How to Add an Arrow to Text Boxes in a Chart in Excel 2013

When creating a text box in Excel 2013, you may want to add an arrow to point directly to the object or part of the chart you’re referencing. To add an arrow, follow these steps: [more…]

How to Create Charts via the Quick Analysis Tool in Excel 2013

For those times when you need to select a subset of a data table as the range to be charted in Excel 2013 (as opposed to selecting a single cell within a data table), you can use the new Quick Analysis [more…]

How to Move Embedded Charts to Chart Sheets in Excel 2013

Although Excel 2013 automatically embeds all new charts on the same worksheet as the data they graph, you may find it easier to customize and work with it if you move the chart to its own chart sheet in [more…]

The Select Data Source Dialog Box in Excel 2013

In Excel 2013, when you click the Select Data command button on the Design tab of the Chart Tools contextual tab (or press Alt+JCE), Excel opens a Select Data Source dialog box. The controls in this dialog [more…]

How to Add Data Tables to Charts in Excel 2013

Sometimes, instead of data labels that can easily obscure the data points in the chart, you’ll want Excel 2013 to draw a data table beneath the chart showing the worksheet data it represents in graphic [more…]

How to Save a Customized Chart as an Excel 2013 Template

After going through extensive editing and formatting of one of Excel’s basic chart types, you may want to save your work of art as a custom chart type that you can then use again with different data without [more…]

How to Format the X and Y Axis Values on Charts in Excel 2013

When charting a bunch of values, Excel 2013 isn’t too careful how it formats the values that appear on the y-axis. If you’re not happy with the way the values appear on either the x-axis or y-axis, you [more…]

How to Create Side-by-Side Time Comparisons in Excel Reports

One of the most common concepts used in Excel dashboards and reports is the concept of trending. Comparativetrending is a simple concept. You chart two or more data series on the same chart so that the [more…]

Trending Dos and Don’ts for Your Excel Dashboards and Reports

One of the most common concepts used in Excel dashboards and reports is the concept of trending. A trend is a measure of variance over some defined interval — typically time periods such as days, months [more…]

Start the Vertical Scale at Zero on Trending Charts for Excel Reports

One of the most common concepts used in Excel dashboards and reports is the concept of trending. The vertical axis on trending charts should almost always start at zero. The reason it’s [more…]

Dashboards and Reports: Leverage Excel’s Logarithmic Scale

In some situations, your trending data for your Excel dashboard may start with very small numbers and end with very large numbers. In these cases, you end up with charts that don’t accurately represent [more…]

Excel Dashboards and Reports: Apply Creative Label Management

As trivial as it may sound, labeling can be one of the sticking points to creating effective trending components for your Excel dashboards and reports. Trending charts tend to hold lots of data points, [more…]

How to Create Stacked Time Comparisons in Excel Reports

One of the most common concepts used in Excel dashboards and reports is the concept of trending. A trend is a measure of variance over some defined interval — typically time periods such as days, months [more…]

How to Trend Data with a Secondary Axis in Excel Reports

Comparative trending, commonly used in Excel dashboards and reports, is where you chart two or more data series on the same chart so that the trends from those series can be visually compared. In some [more…]

Format Specific Trending Periods in Your Excel Dashboards

One of the most common concepts used in Excel dashboards and reports is trending. Some of your trending components may contain certain periods in which a special event occurred, causing an anomaly in the [more…]

Use Dividers to Mark Significant Events in Excel Dashboards

One of the most common concepts used in Excel dashboards and reports is trending. Some of your trending components may contain certain periods in which a special event occurred, causing an anomaly in the [more…]

Represent Forecasts in Your Trending Components in Excel Dashboards

One of the most common concepts used in Excel dashboards and reports is trending. Some of your trending components may contain certain periods in which a special event occurred, causing an anomaly in the [more…]

Use Directional Trending in Your Excel Dashboards and Reports

Trending is very popular in Excel dashboards and reports. A trend is a measure of variance over some defined interval — typically time periods such as days, months, or years. A [more…]

Smooth Data in Your Excel Dashboards and Reports

Trending is very popular in Excel dashboards and reports. A trend is a measure of variance over some defined interval — typically time periods such as days, months, or years. [more…]

Listings:1-2526-35

Sign Up for RSS Feeds

Computers & Software
Great Gadget Giveaway -- Enter to Win!

Inside Dummies.com