How to create a chart in MS Excel to show the sales of a store per month:
Assuming you have a dataset with the following columns:
Month (column A)
Sales (column B)
1. Select the entire dataset (A1:B12)
2. Go to the “Insert” tab in the ribbon
3. Click on the “Column” chart icon (or select “Column” from the chart types)
4. Choose the “Clustered Column” chart subtype
5. Click “OK”
This will create a chart showing the sales for each month.
Example:
| Month | Sales |
| — | — |
| Jan | 1000 |
| Feb | 1200 |
| Mar | 1100 |
| Apr | 1300 |
| May | 1400 |
| Jun | 1500 |
| Jul | 1600 |
| Aug | 1700 |
| Sep | 1800 |
| Oct | 1900 |
| Nov | 2000 |
| Dec | 2100 |
Result:
A column chart will be displayed, showing the sales for each month, with the months on the x-axis and the sales amounts on the y-axis.
You can customize the chart as needed by adding a title, labels, and formatting the colors and design.
Note: You can also use other chart types like Line, Pie, or Bar charts depending on your data and preferences.