• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to create a graph chart?

Nagem Saad

New Member
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.
 

Attachments

  • Graph.xlsx
    13.2 KB · Views: 4
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
 
upload_2015-10-1_22-39-28.png

see attached file:

Please note the improved data layout

ps: Don't use Merged Cells
 

Attachments

  • Copy of Graph.xlsx
    17.1 KB · Views: 1
Back
Top