Microsoft Excel has the tools to create a variety of chart types, from pie charts to scatter plots. The chart you choose depends on the type of data you want to display. For sales charts, you may want to create a line chart, showing the pattern of company sales over time. But you also could form a column chart, comparing the number of sales for different products. Tips Writer Bio