How to create a Column Chart in Excel
How to create a Column Chart in Excel
Learn how to create a Column Chart in Microsoft Excel. This tutorial talks about what a column chart is and then demonstrates how to create a simple Column Chart in Excel with easy to follow steps.
Create a Column Chart in Excel (and sample data):
https://www.techonthenet.com/excel/ch…
Excel Charts:
https://www.techonthenet.com/excel/ch…
Excel Tutorials:
https://www.techonthenet.com/excel/in…
Don’t forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…
Content
0 -> A column chart is a type of graph in Excel
that uses vertical bars to represent your data
6.4 -> You can use a column chart
when you want to compare values across categories
12.84 -> To illustrate how to create this chart,
let's look at a simple example
17 -> Here we have a table of data
containing monthly sales and expenses
22.24 -> Let's use a column chart
to graph this information
26.34 -> To get started, highlight the data
that you would like to use for the column chart
31.38 -> In this example, we have
selected the range A1:C7
36.4 -> Next, select the Insert tab in the toolbar
at the top of the screen
42.64 -> Click on the Column Chart button
in the Charts group
45.08 -> and then select a chart
from the drop down menu
47.74 -> If you hover over each choice
in the drop down menu
51.8 -> it will show you a preview of your data
in the highlighted chart format
56.98 -> In this example, we have selected the first chart
in the "2-D Column" section called "Clustered Column"
63.48 -> Let's move this chart
over a bit to the left
68.48 -> This column chart has rectangular bars
to represent both the Sales and the Expense numbers
74.74 -> The Sales values are displayed
as blue vertical bars
78.98 -> and the Expenses are displayed
as orange vertical bars
83.02 -> You can see the axis values on the left side
of the graph for these vertical bars
88.74 -> Finally, let's update the title
for the column chart
92.76 -> To change the title, click on the chart title
at the top of the graph object
98.12 -> Enter the text that you would like
to see as the title
101.4 -> In this example, we have entered
Sales and Expenses as the title for the chart
107.26 -> This completes our example of how
to create a column chart in Excel
112.56 -> If you would like to see
more examples of charts
115.8 -> or would like to download the sample data
we used for this tutorial
119.06 -> please visit our website at
TechOnTheNet.com
122.6 -> if you have found our tutorial helpful,
please leave a like on this video
126.96 -> and don't forget to subscribe
to our YouTube channel for more great Excel tutorials
Source: https://www.youtube.com/watch?v=pIlEcUzy7p0