Charts are a great way to represent your data in a visual form in order to better understand your dataset and get hidden insights which otherwise you wouldn't be able to.
Microsoft Excel offers a variety of chart options and in this article I will show you how to make and customize them to your needs, using the most common chart types.
In this article you will learn how to:
Every type of chart in Excel will require you to go through the same setup process. After you learn how to create one chart, you will know the rest as well. First, you will have to select your data. You can do this in a variety of ways:
There are two main ways to insert a chart to your spreadsheet:
One of the more popular chart types is the line chart. They work well for visualizing trends across a time period or presenting categories when their order is necessary. Excel gives you a few options on how to display charts:
For instance, we have total sales of products over a six month period. To display a line chart follow these steps:
Another type of chart widely used in visualization is a column or bar chart.
These charts also work well with the sales data where we used a line chart for. Their foremost goal is to compare data categories along with changes over time. To display a bar chart follow these steps:
A pie chart is an excellent approach to visualize a single categorize of the complete dataset.
Working with our sales dataset, let’s say we want to view sales for only the HP Towers products over the six-month period.
In comparison to other charts in this article, waterfall charts might not be as popular, but it is a very useful chart type when it comes to visualizing increases and decreases in financial datasets. There’s only one type of waterfall chart in Excel, however, it's appearance is still customizable in the same way as other charts.
You could use a waterfall chart to display the ups and downs of monthly income, sales percentages, or inventory counts.
The mentioned charts in this article are certainly not the extent of what you can create in Excel. To see other recommended charts based on your dataset go to Insert tab > Recommended Charts button. You can browse the Recommended Charts list if you aren’t confident which chart type would best describe your dataset.
In order to see the list of all available charts in Excel, click the All Charts tab. There are numerous choices to choose from along with the traditional chart types. Once you make your decision, clicks OK and the chart will display on your spreadsheet.
Once you chose your chart, you can begin customizing it with a variety of possibilities. Select your chart and small menu icons will appear on the top right representing Chart Elements, Chart Styles, and Chart Filters menus. Let's look into what each of these options can offer to us. (keep in mind that not every chart has these options)
Here you can select elements you would like to include on your charts such as axes, data labels, gridlines, and a legend.
These choices vary depending on the chart type you use. Certain elements let you customize it even further. For example, if you want a legend, you can choose the location it where to display it on the chart.
Using our bar chart from above, let’s customize some elements. We’re going to include axes, chart title on top, a data table with legend keys.
Here you can customize the look and feel of your chart in the same way as you would go to the Design tab > Chart Styles ribbon menu. Let’s give our chart a different feel.
As you hover your mouse over the various styles and colors, you can preview of how your chart would look. Click when you see one you like.
Additionally, a good practice would be to use colors that are aligned with the company colors you are analyzing. You can do this by selecting your chart and navigating to Design Tab > Change colors menu.
For additional color schemes for your chart, you can navigate to Page Layout tab > Themes and browse and scan through the options.
Chart Filters offer you the options to quickly add or remove certain data categories. For instance, let's assume we only need the first quarter of sales in our chart.
Select the chart and click the Chart Filters menu button. Here you can uncheck the data categories you want to remove. In our case, we want to remove April, May, and June out of the chart. Click Apply when you are done.
In case you only want to include certain products on your chart, you can use the Series section to remove products. Apply the changes by pressing the Apply button.
Moving your chart to another spot on the spreadsheet is relatively simple. The only thing you have to do is select it and when the four-sided arrow appears, drag the chart to its new location. In case you have to move it to another worksheet, copy the entire chart by applying the shortcut key Ctrl+C and once you navigated to the new location, use Ctrl+V to paste it.
In order to resize your chart, you can achieve it in a similar way by selecting it and drag one of the circles from the corner of the chart in the direction you would like to expand it.
Continue reading here
Are you wondering which product has more value to your needs? What is the main difference between Excel 2019 and Office 365?...