There several ways to create in cell and that includes Excel’s built in Sparklines or using a third party Sparkline Add in, But there are ways to produce bar charts by using Excel without using these feature. This small tutorial will show you how to create one by using the Font type Symbols and using excel formulas.
The advantage of using such a method is that it makes sharing and excel file easy and the recipient does not need to have same add in or version of Excel. So let’s jump start with how to make such graph.
Put your data in appropriate range:
The charts works best when done along-side of the data. So spare some space on the side (preferably right side) of the data.
Get familiar with the REPT