How to create a graph chart?

[Nagem Saad]

Good Afternoon People,

It has been a good day since it's today i found this amazing website,

I have a sheet of monthly material details as can be seen in the attached doc. i was wondering if i can present that sheet in a graph format chart.

it will more helpful if i could know how to do it and if the sequence made are to changed for graph than please assist how the data should be arranged for preparing a graph.

 

[chirayu]

Select Cells A5:F6
Click on Insert Tab
Click on "Column" button
Choose "Clustered Column" option under 2-D Column header

Repeat process for rest

 

[Hui]

See attached file:

 

[Nagem Saad]

Thank you people, as attached can i get the details in that format.

 

[Hui]

see attached file:

Please note the improved data layout

ps: Don't use Merged Cells

 

[Nagem Saad]

Thank you again, i think the previous method is the best for easy review