Excel

We'll be adding more skills over time.

• Create a bar graph in cells

Create a bar graph in cells
If you have numbers going down a column, you can create a simple bar chart in the next column over.

1. Select the first cell in the column next to your numeric data; in this example, you would select C2.
2. Enter the formula =REPT("|",B2)
   To get that character mark, press Shift + \
   If your data is small, this formula will work fine, but if your data is larger, e.g. in the 100s or 1000s, you may want to divide by some factor, such as =REPT("|",B2/10) or =REPT("|",B2/100)
3. Copy the formula down the column by double-click on the fill handle
   
4. Format the column as Arial font size 8 and Bold.