Excel and charts tutorial. In microsoft excel charts are used to make a graphical representation of any set of data. Learn the basics of excel charts to be able to quickly create graphs for your excel reports. Charts allow your audience to see the meaning behind the numbers and they make showing comparisons and trends much easier. 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.
A chart is a visual representation of data in which the data is represented by symbols such as bars in a bar chart or lines in a line chart. What exactly is an advanced excel chart. Take a look in excel and youll quickly notice that theres no shortage of charts available. Click the button on the right side of the chart click the arrow next to legend and click right.
Select a chart on the recommended charts tab to preview the chart. How to build an excel chart. Select insert recommended charts. Click the insert tab.
Get your data ready. A step by step excel chart tutorial 1. Create a chart select data for the chart. In this tutorial you will learn how to insert charts and modify them so they communicate information effectively.
A chart is a tool you can use in excel to communicate data graphically. 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. From the basics like column charts bar charts line charts and pie charts to options you may have less familiarity with like radar charts stock charts and surface charts there are seemingly endless charts you can make within excel.