Lesson#48: Graphical 20X20 multiplication table
![Lesson#48: Graphical 20X20 multiplication table](https://excelabcd.co.in/wp-content/uploads/2018/02/excelabcd-lesson-48.png)
In this post, I will make a graphical 20X20 multiplication table and show the process of making it.
![](https://excelabcd.co.in/wp-content/uploads/2018/02/48-1.png)
Selected two random numbers between 0 to 20 and multiplied both of them.
![](https://excelabcd.co.in/wp-content/uploads/2018/02/48-2.png)
![](https://excelabcd.co.in/wp-content/uploads/2018/02/48-3.png)
Reflected the cell values in merged cells as I have shown in the picture below.
![](https://excelabcd.co.in/wp-content/uploads/2018/02/48-4.png)
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.
![](https://excelabcd.co.in/wp-content/uploads/2018/02/48-5.png)
Selected two input cells. Clicked on Data Validation.
Allow>Whole Number.
Minimum: 0
Maximum: 20
![](https://excelabcd.co.in/wp-content/uploads/2018/02/48-6.png)
Graphical representation of 20×20 multiplication table.
![](https://excelabcd.co.in/wp-content/uploads/2018/02/48-7.png)
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.
Leave a Reply