For example, to determine the number of sales you need to make of a certain product to cover costs, you could use:=(A2*50)-3500Replace "50" with your sale price and "3500" with your costs.

How to Make a Graph in Excel With Word and Number Variables. Microsoft Excel can perform numerous statistical functions, as well as create charts from statistical data.

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.