Step 1: You’ll need to add your data into the Excel spreadsheet, with each column having its own dedicated title. If you make a mistake with the column heading order, just redo or add a new column .

Open the Excel spreadsheet to find the chart. Select the chart. Right-click on it and choose the Select Data option.; Select the data series from the Legend Entries box.; Click the Edit button ...

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.

It provides much of the same basic functionality as Excel, and creating the perfect graph for your data is also just as easy. Highlight the range of data you wish to represent in the graph. Click ...

Figure A shows a simple data set with no real structural issues. The chart to the right is a 2D Column chart that groups each person’s actual sales and target amount. (I entered a new chart ...