Techronology home

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

## Think of cells in Excel as variables – How to

This quick lesson helps you think of cells in Excel as variables. Overview In programming, we have something called variables. We use variables to store information that we may want to change later. Moreover, you can do the same thing in Excel. In fact, Excel has a bunch of cells that allow you to store […]

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

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

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