Below is a short tutorial to help you set up your table accurately, avoid any errors and start creating charts. If you'd like help creating a Pivot Table, you can read our blog How to Create Pivot Tables in Excel.
Create a Line Chart
1. Enter your data
2. Label the rows and the columns
3. Select the data range
4. On the Insert tab, in the Charts group, click the line chart.
5. Click Line with Markers, the chart will appear.
Changing Chart Type
You can change to a different chart at any time.
1. Select the Chart you want to change.
2. On the Design tab, click Change Chart Type.
3. On the left side of the All Charts tab, choose your new chart type.
4. Click OK.
Switch Row/Column
If you want to change the data on the horizontal axis, you can do so by following these steps.
1. Select the Chart
2. On the Design tab, in the Data group, click Switch Row/Column
Legend Position
To move the legend to a different side of your chart, follow these steps.
1. Select the Chart.
2. Click the + button on the right side of the chart, click the arrow next to Legend and click where you would like the legend to appear.
Good luck creating your charts! If you would like to learn more about using Excel effectively then check out our Excel Courses. We cover all skill levels.
phone
email
enquiry
