More Information

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

Tips, Tricks, and Answers

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

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 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.

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.