One of the best programs for taking numerical data and putting it into chart format is Excel. The process is simple, it gives the user a good deal of control over how the chart looks, and it draws clean, simple charts.
1. Enter your data into the cells in an Excel spreadsheet and drag over it so that those cells are selected.
2. Click on the chart icon. That will get you into Excel’s Chart Wizard.
3. Chart Wizard is a four-step process that Excel uses to draw the chart. The first thing to do is select the type of chart that you want it to draw.
4. Chart Wizard will make an initial drawing of your chart. Here you can check to make sure all of your data are included and that the chart is oriented in the correct way.
5. The next step offers you a variety of options in deciding how your chart will look. Each of the file tabs will take you into a window that will allow you make selections about the appearance of different parts of the chart. You should explore all of these options and become very familiar with the things you can do with your chart.
6. In this particular chart, we decided to eliminate the legend because a chart that has only one type of data does not need a legend. The legend function of Chart Wizard allows us to do that.
7. The final step of Chart Wizard asks where we want to put the chart. In this case, we will put it back onto the worksheet.
8. The chart will appear on the worksheet, but it can still be changed. You can do that be double-clicking on various parts of the chart. That will take you back into the Chart Wizard options.
9. Here, for instance, we have eliminated the gray background.
10. When you have manipulated the chart to the point where you are satisfied, the Excel file should be saved with the chart on the spreadsheet. Click on the chart and copy it into the computer’s clipboard. Then you can paste it into a photo editing program such as Photoshop to save it into whatever format you need.
