Microsoft Excel Chart Exercise: Microsoft Excel chart is used to visualize data that is easy to understand. In other words charts in Excel or in any application are used to communicate visually with the audience. It is a visual communicator.
There is various type of charts in Excel that you can use to visualize your data. These are column charts, line charts, bar charts, pie charts, area charts, Scatter, surface charts, and many others.
But let’s understand today about column charts in a simple and easiest exercise on excel charts.
- Create a table, see the picture below. Enter the appropriate data that you want to show in the chart. In this example, we are using the India-Pakistan T20 cricket match, in which we are highlighting scored run per over.
2. Calculate the total runs of each team. By using Auto Sum (please see the picture below)
3. Now select all three rows and columns, as you can see in the picture below.
4. After this go to insert and select column chart.
5. Now stretch the chart from the edges as looking in the image below. Add the heading of the chart, OX axis, and OY axis Values; please see the image below.
It’s because we can use it as a column chart to visualize a comparison between 2-3 columns of data such as in the final image above, you can see that on the OX axis, you can see overs. And on OY Axis, there are runs in two different column bars in colors highlighting team runs. You often see this kind of chart in a cricket match on TV.
While this is a basic exercise, practicing it means a lot to beginners in Excel.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?