charts

## Add an average line to a column chart – How to

Add an average line to a column chart. This lesson shows you how to add an average line to a column chart in Excel. For the purpose of this lesson, we use a previous column chart that we already created. In addition, all functions in this lessons were done on a Windows PC, in Excel […]

## Add data labels to a chart in Excel – How to

The following lesson shows you how to add data labels to a chart in Excel. Since we use Excel on a Windows PC to complete this task, we suggest you do the same. However, you can still follow along on any operating system that has Excel. Introduction Data labels shows the value of a particular […]

## Add footnote to category label in Excel – How to

In this quick tip, we show you how to add a footnote to a category label in Excel. Also, we use Excel 2007 or higher, on a Windows PC, for this lesson. However, you can follow along on any system that has Excel. Steps to add footnote to category label in Excel Follow the steps […]

## Change number format of value scale – How to

Overview This quick lesson shows you how to change the number format of a value on the y-axis of a column chart, in Excel. So, in the above chart, we want to change 200 to \$200, and keep all other values the same. Overall, we think that will add value to the chart, and make […]

## Change the value scale of a chart to improve view – How to

This quick tip shows you how to change the value scale of a chart to improve its view in Excel. Since we use Excel on a Windows PC to complete this task, we suggest you do the same. However, you can still follow along on any operating system that has Excel. Introduction So, this chart kind […]

## Creating a basic column chart in Excel – How to

Creating a basic column chart in Excel. Overview A column chart allows you to view data across various categories. For the most part, vertical bars show the amount of data in a visual format. Thus, allowing you to easily analyze that data. For example, you can see which group did better. Or, which category needs […]

## Make the plot area of your column chart better – How to

Introduction One way to make the plot area of your column chart better is by reducing the space between the columns. Overall, the vertical spacing of the above chart is great. So, all we really need to do is increase the width of the columns. Thus, we will improve the spacing of this chart, in […]

## Stretch average line across plot area, in Excel – How to

This lesson illustrates how to stretch an average line across the plot area, Excel. For the purpose of this tutorial, we use Excel 2007 or higher, on a Windows PC. If you are using another system, then feel free to follow along. Overview When you create a line chart or combine it with a column […]