Online Excel Chart Tutorial

Use scatter with straight lines to show scientific xy data.

Online excel chart tutorial. How to build an excel chart. Discussion a chart is a tool you can use in excel to communicate data graphically. Line charts are used to display trends over time. Before she dives right in with creating her chart lucy should take some time to scroll through her data and fix any errors that she spotswhether its a digit that looks off a month spelled incorrectly or something else.

Use a line chart if you have text labels dates or a few numeric labels on the horizontal axis. Click any of these icons to make the corresponding type of chart. Select the data youd like to include in your graph then open the insert section of the ribbon. You can easily change to a different type of chart at any time.

On the design tab in the type group click change chart type. Select insert recommended charts. To create a line chart in excel execute the following steps. Heres how to make a chart or graph in excel online.

If youre an excel beginner or an intermediate and want to learn excel this is the perfect place for you to start. You can select the data you want in the chart and press alt f1 to create a chart immediately but it might not be the best chart for the data. On the left side click column. Youll find an assortment of icons for making charts.

Take a tour download template formula tutorial download template make your first pivottable download template get more out of pivottables. If you want to display the animals instead of the months on the horizontal axis execute the. Charts allow your audience to see the meaning behind the numbers and they make showing comparisons and trends much easier. Get your data ready.

In this tutorial you will learn how to insert charts and modify them so they communicate information effectively. This page gives you access to a completely free online excel training 26 video lessons with 12 hours of learning. Select data for the chart.