All courses available in-class or via remote login

How to create a Chart in Excel

June 10, 2020
Visualising data can be the best way of helping you and your audience to identify relationships and spot trends in data. Creating charts and visuals can be done rather easily in Microsoft Excel. However there are common mistakes that can cause data to be misrepresented and misinterpreted. Common issues involve numbers or dates not formatting correctly, not gathering all data from a table and labels being incorrect. The key recommendation when starting our with charts is the be familiar with your data. Ask yourself if your graphs make sense and tell a consistent story.

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.

What is Remote Training?

Valued by Individuals

 

4.8/5
Over 21470 Reviews
Jagg was an excellent trainer - very patient, had lots of options for people who didn't have the newest versions. I feel really confident about what I learnt today and I am very happy I did this course! -Power BI Beginner Adelaide
Melissa - Power BI Beginner, .
Excellent! Very knowledgeable instructor. -Power BI Beginner Adelaide
Jason - Power BI Beginner, .
Great course, very informative. Great instructor, very helpful -Power BI Beginner Adelaide
Sarah - Power BI Beginner, .
Great session, moves at a good pace with support when needed. Thanks -Power BI Beginner Adelaide
Matthew - Power BI Beginner, .
Excellent! -Microsoft Applications - Customised Sydney
Candice - Microsoft Applications - Customised, .
Very helpful -Microsoft Applications - Customised Sydney
Janet - Microsoft Applications - Customised, .
The learning environment and facilities are great. Ken knew the course content and is a friendly trainer.. -SharePoint Site Owner Melbourne
Robbie - SharePoint Site Owner, .
Thank you Ken Great 2 day of learning lots of information, looking forward to making our New Company SharePoint Site -SharePoint Site Owner Melbourne
Natasha - SharePoint Site Owner, .
Thank you Ken, I feel a lot more empowered and up-skilled with regards to SharePoint. I am looking forward to supporting my organisation to leverage SharePoint as one of collaboration and information management tools. -SharePoint Site Owner Melbourne
Annita - SharePoint Site Owner, .
Found it beneficial. Ken was extremely knowledgeable -SharePoint Site Owner Melbourne
Toby - SharePoint Site Owner, .
Great course, learnt a lot for the trainer. -Power BI Beginner Sydney
Aaron - Power BI Beginner, .
A good session however some revision of content from the intermediate course, which meant doing those two courses close together made those portions somewhat repetitive. Jagg was a good presenter and a good pace. -Excel Advanced Adelaide
Belinda - Excel Advanced, .
Jagg went above and beyond to help us learn the advance functions of excel. -Excel Advanced Adelaide
Ateeq-ur - Excel Advanced, .
Jagg was a great instructor - he stepped us through at a good pace, paused well to take q's and was well prepared. -Excel Advanced Adelaide
Hannah - Excel Advanced, .
Excellent range of advanced skills presented -Excel Advanced Adelaide
Oliver - Excel Advanced, .
Jag was excellent! Clear and thorough. I was a bit worried doing it remotely but found it better! Highly recommend. -Excel Advanced Adelaide
Agland - Excel Advanced, .
Was a very good informative session from Jag. -Excel Advanced Adelaide
Nilmini - Excel Advanced, .
Thank you. Well taught, clearly presented, and valuable lessons. Would recommend. -Excel Advanced Adelaide
David - Excel Advanced, .
Good pace, great course -Excel Intermediate Melbourne
Gemma - Excel Intermediate, .
Was a very informative course. John is a very patient instructor. Gives clear instructions. -Excel Intermediate Melbourne
Sonia - Excel Intermediate, .

Trusted by Business

Procured by Government

Map of Australia