In this video, we’ll look at how to create a basic column chart in Excel. We’ll also use look at custom number formats to show dates as month names, and currency in thousands.
Here we have data for monthly sales of a small business for the year 2016.
Let’s build a column chart to plot this data.
To start off, put the cursor anywhere in the data, then visit the Insert tab on the ribbon.
Since I want a column chart, I’ll use the bar icon to the right of Recommended Charts, which contains both column and bar options.