Lesson#48: Graphical 20X20 multiplication table

Posted on Posted in Excel Features No Comments Tagged with , ,
Lesson#48: Graphical 20X20 multiplication table

In this post, I will make a graphical 20X20 multiplication table and show the process of making it.

Merged and centered these cells for showing data bar as I have shown in the picture below.

Selected two random numbers between 0 to 20 and multiplied both of them.

Selected both input cells, right-clicked on them, clicked on Format Cells>Protection Tab> and then unpicked the locked.

Reflected the cell values in merged cells as I have shown in the picture below.

Selected the three merged cells Conditional Formatting>Data Bars>More Rules 
Ticked on Show Bar Only checkbox.
Below Shortest Bar and Longest Bar, I have selected the type Number and Shortest Bar value 0,
Longest Bar value is 20X20=400.

Selected two input cells. Clicked on Data Validation.
Allow>Whole Number.
Minimum: 0
Maximum: 20

Graphical representation of 20×20 multiplication table.

This is a simple example and idea of working with Conditional Formatting. This type of idea can be implemented in your spreadsheet works to make your data presentation more unique.

Download here.

See also  Lesson#103: 4 Ways to find duplicate values in a worksheet
About

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *

*