spot_img

Bump Chart in Excel

We are going to insert a bump chart. I am using Microsoft Excel 2013, and you can use other version to perform the insertion. Prior to inserting the bump chart, I will assume that you have data available, which is something like this:dataNote: The data can be as you like, it is about ranking the products or anything else, and you can place any data you want.

How to create a Bump Chart?

Copy the time and thing you would like to rank into a new place in the same sheet. In this case, we are going with products.

click cell

Mark the same quantities of cells with data in the data you initially has.

quantities

With the marked area, click on the formula bar, and type in =RANK(B2; all the cells in the same column, for example B$2:B$5). The full formula in my example is =RANK(B2,B$2:B$5,0). Press CTRL + Enter.

rank function

Click on any of the rank cells that is still marked.

copy rank

Click on insert tab (1), and then click on Line chart (2).

insert line chart

Choose a line chart without marker in 2-D.

chart without marker

Right click on the Y axis (1), and click on format axis (2). ¨

format axis

In the bound, type 0 as the minimum (1), 4 as maximum (2), 0 as minor (3), 1 as major (4), and then check values in reverse order (5).

bounds

Note: If you have 3 different things you are ranking, than four, you should set the maximum (2) to 3. You can also add an axis title if you wish.

Our Bump Chart:

bump chart example

Template

You can download the Template here – Download
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell