Microsoft excel charts tutorial. You can use data labels to focus your readers attention on a single data series or data point. Virtual workshops and training. In the new versions of excel hover the cursor over a chart type or sub type on the insert ribbon to display a description of the chart. How to build an excel chart.
In this beginning level excel tutorial learn how to make quick and simple excel charts that show off your data in attractive and understandable ways. Take a tour download template formula tutorial download template. To move the legend to the right side of the chart execute the following steps. To create a line chart execute the following steps.
Create a chart in excel 2007 2010 2013 and newer versions note. Charts allow your audience to see the meaning behind the numbers and they make showing comparisons and trends much easier. Click the chart type from the charts section of the ribbon see image. A step by step excel chart tutorial 1.
This tutorial covers all the basics including 1 getting to know the elements of a chart 2 modifying a basic chart to meet your needs 3 applying a predefined chart layout and chart style for a professional look 4 adding eye catching formatting to a chart and 5 reusing charts by creating chart templates. A chart is a tool you can use in excel to communicate data graphically. Microsoft excel can also be used to balance a checkbook create an expense report build formulas and edit them. Select a chart on the recommended charts tab to preview the chart.
Select insert recommended charts. Use a scatter plot xy chart to show scientific xy data. Click the button on the right side of the chart click the arrow next to legend and click right. Excel is supported by both mac and pc platforms.
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. Click the insert tab. Line charts are used to display trends over time. Use a line chart if you have text labels dates or a few numeric labels on the horizontal axis.
Get your data ready.