how to plot a graph in excel with formula

The above formulas work well when you are dealing with positive values. See example 3 in the attached Excel file. For example, capital “J” will display a smiling face while a capital “L” will display a sad face. It should be noted that by changing the “n” in the above mentioned formula you can display different images. See example 2 in the attached Excel file. By way of example, the formula would look like this =REPT (“n”,A1/10). Should you wish to decrease the length of the bar chart simply divide “A1” in the above formula by 10 or by whatever number makes the most sense. Please refer to example 1 in the attached Excel file.ĥ. This formula simply tells Excel to repeat the value stored in between “ “ by the number in cell A1.Ĥ. In column B1 enter the following formula: =REPT (“n”, A1). in cell A1 enter the value 10, in cell A2 20 etc.Ģ. In column A enter the values you want to display i.e. This is a simple tutorial on how to create and display a bar chart in a cell a technique that works very well when creating management reports.ġ. Return to Charts Home How to Create and Display a Chart in a cell Create, Save, & Use Excel Chart Templates

How to plot a graph in excel with formula