How to Make a Profit & Loss Spreadsheet. ... How to Hide Empty Data in Excel Graphs. If you have an Excel spreadsheet that contains... How to Change Your Company Name in Google AdWords.

How to Make and Add Labels on a Graph in Excel. For even the most new-to-the-program users, compiling a graph in Microsoft Excel is fairly intuitive.

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.

For instance, if you have a profit loss of -500, to get the absolute value, you would type: =ABS(-500) The function will return 500, disregarding the negative sign.