Charts

Tips, Tricks, and Answers

The following articles are available for the 'Charts' topic. Click the article's title (shown in bold) to see the associated article.

Add Data Labels to a Chart
Adding labels to a chart can make the information presented in the chart more understandable. Excel allows you to add different types of data labels to your charts, as discussed in this tip.

Adding Titles to a Chart
Titles can be a great addition to any chart. They help provide explanatory information about the information in the chart. Here's the quick way to add all the titles you need.

Adjusting Tick Mark Intervals
Create a chart in Excel, and you may find that the tick marks shown on the axes in the chart aren't to your liking. It is easy to change the interval at which the tick marks occur by using the information in this tip.

Building a Log/Log Chart
Excel allows you to easily create several types of charts. If you want a more esoteric type of chart (such as a log/log chart), then you need to get a bit more creative in your chart-building endeavors.

Changing a Chart's Type
Charts can either be embedded in a worksheet or take up an entire sheet by themselves. Changing from one type of chart to the other is easy to do by using a control on the Design tab of the Ribbon.

Changing Colors in Charts
Need to change the color of different parts of your chart? It's easy to do when you apply the technique described in this tip.

Changing Data Series Ordering
Once you create a chart, you aren't limited to keeping the data series in the order they originally appeared. You can shift them around by applying the techniques used in this tip.

Changing Fonts Used in Charts
When formatting a chart, you might want to change the characteristics of the font used in various chart elements. This can be easily done using formatting techniques you may already know.

Controlling Gridlines on Charts
When Excel creates a chart for you, it may include gridlines that appear being the data series. If you don't like these gridlines or if you want to change how they appear, you can easily do so.

Deleting Charts
After a while, you may no longer need a particular chart in your workbook. Here's how to get rid of the unwanted graph.

Formatting a Chart's Axis
Create a chart in Excel can you can then modify it almost any way you desire. One modification is to adjust the color or pattern applied to an axis. This tip examines the ways you can do this.

Specifying an Axis Scale
If you don't like the scale that Excel automatically applies to an axis in your chart, you can specify your own scale. It's easy to do by following the steps in this tip.

Specifying How Excel Plots Empty Cells
When creating a chart from information that contains empty cells, you can direct Excel how it should proceed. This tip explains the process.

Tying Callouts to a Location on a Chart
When you create a chart, you may need to add one or more callouts that are used to annotate information presented in the chart. This tip presents a handy way you can tie those callouts to specific data points on the chart.

Using Graphics for Bars in a Bar Chart
You can spice up your bar chart by using a graphic, of your choosing, to construct the bars. This tip shows how easy it is to pick and use your graphic.

 

More Information

The following are additional topics related to the subject of 'Charts'. A bracketed number after the topic indicates how many articles are related to that subject.