how to

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

## Adding numbers in Excel – How to video

This quick video lesson is about adding numbers in Excel. For the purpose of this lesson, we use Excel 2007 or higher, on a Windows PC. However, you are free to follow along on any computer that has Excel. Video – Adding numbers in Excel As you see, in our list, all we did was, […]

## Basic math operators in Excel – How to

There are 5 basic math operators in Excel. The basic math operators in Excel Below is a table representing the basic operators in Excel. So, the operation and result columns are based on A1 equalling 6, and B1 equalling 2. Operator Meaning Operation Result + Addition =A1+B1 8 – Subtraction =A1-B1 4 * Multiplication =A1*B1 […]

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

## Create a formula to solve Ax+B=C – How to

This lesson shows you how to create a formula to solve Ax+B=C. Overview Ax+B=C is also known as the equation of a line. The way we plan to create the formula is by solving for x. Overall, it is all about going through the motions. In the end, we want x to be on one […]

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