MS Excel is software that allows you create spreadsheets. Did you know that with Excel, you can use that data in the spreadsheet to create charts and graphs? You can use charts and graphs as another way to represent and display your data. Follow the brief tutorial below to see how you can create graphs and charts using MS Excel.
1. Create a worksheet that includes the data you want to put in a chart (it’s best to use numerical data like numbers, dates, years vs. things like places, people, products, etc.- you want to show the progress of something over time, for example).
2. Select the cells in the worksheet which you want to use for the
chart.
3. On the Insert tab, Click Charts
.
4. Choose a chart type (column, bar, lie, pie, scatter, area and so on)
5. Choose a chart subtype (clustered, stacked, 100% stacked and so on. You also can choose custom type to customize your chart).
6. Click Next button..
7. Click Series (you can add or remove series, edit series’ name and value, edit category (x) axis label).
8. Click Next button.
9. Click Title (you can edit chart title, category (x) axis and value (y) axis).
10. Click Axes (you can edit primary axis)
11. Click Gridlines (you can edit gridlines)
12. Click Next button.
13. Choose place of chart, as new sheet or as object in.
14. Click Finish button.
Now you will have a chart that represents your data.
Robin Lu
November 29, 2007 at 5:14 am |
Great post, Robin! I like the screenshots – nice touch.