At most one email a week. Unfollow anytime with one click.
Transcript
The full narration of this video. The current sentence is highlighted while the video plays; click any sentence to jump there.
Show transcript
Introduction
This is the final result we will create, 3 charts from one sales table. A column chart to compare products each month, a line chart to see the sales trend of coffee, and a pie chart to see the proportion of each product in June. Let's start. Hello, welcome to the Excel tutorial for beginners, creating charts in Excel. Numbers are easier to understand when displayed as images. We will create column, line, and pie charts from the monthly sales data.
Step 1: Monthly Sales Data
This is the sales data for 6 months for 3 products, coffee, tea, and milk. From this series of numbers, it's hard to see which product is the most popular, or how the trend looks. Charts help us see this in an instant. The condition is that the data must be neat. The first row contains column titles, and the first column contains categories. First, select all the data, from A1 to D7, through the name box.
Step 2: Column Chart with Alt F1
Then press Alt and F1. With just one shortcut, Excel creates a column chart instantly. This chart compares 3 products for each month, with different colors and labels underneath.
Step 3: Moving the Chart
The chart appears covering the data, so we move it. Drag from the empty space in the corner of the chart, then release it to the right of the table, around column G. To change its size, drag the corners of the chart. Place the chart in a place that does not cover the table, so that numbers and images can be read together. Arranging the layout like this makes the report look neat and easy to follow for the reader.
Step 4: Chart Title
Each chart needs a clear title. Double-click the chart title, press Ctrl A to select all text, then type, monthly sales of coffee, tea, and milk. Click outside the chart to finish. A good title directly explains the content of the graph. Avoid generic titles like 'Graph 1', because readers won't know what they're looking at. Specify what is being measured, and if necessary, the period.
Step 5: Line Chart for Trends
Now, a line graph, which is suitable for viewing trends over time. Select H1 to B7, which is the month and coffee sales. Open the Insert tab, then select the line graph. The line rises from month to month, indicating that coffee sales are continuously increasing. Line graphs are most suitable for data that is ordered according to time, such as daily, monthly, or yearly, because our eyes easily follow the direction of the line. Move the graph below the first graph, and give it the title 'Coffee Sales Trend'.
Step 6: Pie Chart for Proportions
Finally, a pie chart to see the proportions. Select the product title in B1 to D1, then hold the control and select the June sales in B7 to D7. Open the Insert tab and select the pie chart. We can see what portion of June sales comes from coffee, tea, and milk. Pie charts are only suitable when the number of slices is small and all slices together form a complete total. If there are too many slices, a column chart is easier to read. Give the title 'June Sales Proportions'.
Step 7: Chart Updates Automatically When Data Changes
The graph is connected to its data. Try changing the June coffee sales number to 250. See, the column in the column chart becomes taller, the line in the line chart rises, and the coffee slice in the pie chart grows larger. Everything changes automatically. This is the biggest advantage of creating graphs directly from the table. We don't need to redraw them. Just update the numbers, and the next month's report is ready with always-up-to-date graphs.
Step 8: Saving the Results
The graph is complete. Press Ctrl S to save. Remember the three rules for selecting a chart: columns for comparison, lines for trends, and pie charts for proportions of a single total. Before closing, check each chart again. Is the title clear? Are the positions not overlapping? And is the chart type suitable for the message we want to convey? With this habit, our reports will always look nice and be easy to understand.
Done! Three Types of Charts from One Table
Done. We have created column, line, and pie charts from one detailed table. Thank you for watching. See you in other tutorial series. Want to master Excel for work and business? Cerdas Inovasi Digital offers Excel and Office courses, template creation services, report and dashboard Excel, as well as sells the practice files of this tutorial. Contact us via WhatsApp, or visit cerdasinovasidigital.com. Thank you for watching. See you in other tutorial series.
Ask the class material
Type a question or keyword; we find the part of this episode that explains it and jump the video there.
My notes
Notes are saved with the current video time and are only visible to you.
Questions & answers
Stuck on a step? Ask here; the instructor and other learners can answer.
No questions yet.
Your instructor
Cerdas Inovasi Digital Team
Software developers, BIM & 3D engineers, and AI practitioners
52 video classes1,276 episodes
We build software, BIM models, games and AI automations for clients every day, and turn that hands-on work into step-by-step classes: every step is shown on screen and comes with a PDF guide you can keep.
