How do i graph this table as a clustered bar graph on excel? I can't get it work.

enter image source here

I have Excel 2016. I can never get anything to graph on excel unless i spend several hours trying.

1 Answer
Sridhar V.
May 21, 2018

#" "#
Please read the explanation.

Explanation:

#" "#
#color(green)("Step 1 :"#

Given Excel data set :

enter image source here

#color(green)("Step 2 :"#

From the data set, Select the required region for graphing:

enter image source here

#color(green)("Step 3 :"#

enter image source here

Select:

Insert #rArr# Insert Column or Bar Chart

#color(green)("Step 4 :"#

Select:

enter image source here

#color(green)("Step 5 :"#

enter image source here

Choose an appropriate Chart Title.

Save you Excel work.

Hope this solution process meets your expectations.

Related questions
Impact of this question
911 views around the world
You can reuse this answer
Creative Commons License