Ms Excel Practical Question with solution; How to create a bar chart of Products?

Question:- Create a bar chart with the following data in Sheet 1. (5)

Chart Title:- 'Crop Production on 2005-2010'. 

X-Axis:- Year

Y-Axis:- Production

	2005	2006	2007	2008	2009	2010
Rice	3476	3485	3488	3490	3499	3500
Wheat	3000	3200	3500	3700	3900	4300
Maize	2854	2967	3087	3154	3223	3410
Barley	4000	3800	4200	4500	4800	4000

Solution:-

To create a bar chart, follow these steps:

Step 1:- Enter data in a spreadsheet.

Step 2:- Select the data.

Step 3:- Depending on the Excel version you're using, select one of the following options:

-Excel 2013: Click Insert > Insert Bar Chart icon, and select a Bar chart option of your choice.

-Excel 2010 and Excel 2007: Click Insert > Bar, and select a Bar chart option of your choice.

You can optionally format the chart a little further. See the list below for a few options: