« Back

Office 365 – Excel: Using Charts

Excel added several new charts to its repertoire. Students can use these charts to show research and make predictions.

  1. Select your data and click on “Recommended Charts” in “Insert” tab.
  2. You will get a list of charts that are compatible with your data.
  3. Choose Waterfall to show the cumulative effect.
  4. In “Design” tab you can save your chart in its own place by clicking on “Move Chart”.
  5. Tick “New sheet” and click ok.
  6. Now, you can add the chart to Sway or PowerPoint for example.
  7. From “Insert” tab you can create a “Sparkline”, which is a chart that fits into a single excel unit.
  8. Click on “Sparkline” and select your data range.
  9. Click “Ok” and your Sparkline will show under your data.
  10. For another example:
  11. Select your data and go to “Recommended Charts” in “Insert” tab.
  12. Choose “Pareto” chart.
  13. Pareto chart distributes data in descending oder.

« Back

This article was published in these categories: English version available, for staff, Oamk , GUIDELINE, Bulletins & Guidelines, software, for studentsand tagged , , , , .Add a permalink to your favourites. Follow comments to this post with a RSS feed. Post a comment or leave a trackback: Trackback URL.
Log in to comment this article