Kishan wants to create a column chart to show his expenses in a month. Help Kishan with the steps.
Answers
Answer:
Select the data you want to use for your chart.
Click Insert > Recommended Charts.
Charts group on the Insert tab
On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look.
Recommended Charts tab in the Insert Chart dialog box
Tip: If you don’t see a chart you like, click All Charts to see all available chart types.
When you find the chart you like, click it > OK.
Use the Chart Elements, Chart Styles, and Chart Filters buttons next to the upper-right corner of the chart to add chart elements like axis titles or data labels, customize the look of your chart, or change the data that’s shown in the chart.
Recommended stacked column chart
To access additional design and formatting features, click anywhere in the chart to add the Chart Tools to the ribbon, and then click the options you want on the Design and Format tabs.