You can also use the Graph Wizard in the Dashboard if you want to create a graph to illustrate your results. You can narrow the data you want displayed by using the Filters and Cross Filters. If you are planning to create a chart in Excel you will need to use some basic SQL to create your chart. If you need some practice with SQL (http://www.sqlcourse.com/index.html) this is a great site for learning and practicing. Here is a simple graph that I use I one of my projects.
select b.tc_test_id, c.TS_NAME, c.TS_USER_04, b.TC_STATUS from cycle a, testcycl b, test c
where b.tc_cycle_id = a.cy_cycle_id and b.tc_test_id = c.ts_test_id
and a.cy_cycle ='January 2012'
TC_TEST_ID TS_NAME TS_USER_04 TC_STATUS
3508 Tech Console - 4 button functionality NA Passed
3908 CB - Dispositions show for account numbers with less than 9 char HLP000001225626 Passed
3909 CB - Dispositions show for account numbers with 9 char HLP000001225626 Passed
3949 User-Group Control Center - Clone user as admin IM0000000011214 Passed
3950 HLP - Users that are not in group will not show in assigned to IM0000000011214 Passed
3951 HLP - Modify All contains values in Resolutions HLP000001347756 Passed
3952 HLP - Modify All - Resolve ticket HLP000001347756 Passed
3953 HLP - Modify All - Resolve Multiple tickets HLP000001347756 Passed
3954 ADM_Groups - Display correct Group ID IM0000000011291 Passed
3955 ADM_Groups - Group Request Id matches New Group Passed
3957 QST_questionTemplates HLP000001244438 Passed
3962 HLP Ticket - Automated IT Customer Satisfaction Survey Functionality IM0000000009511 Failed
3963 MNT - Notification sent for State Change IM0000000011334 Passed