can we make reports from an excel sheet(being used as a data src) using sql server 2005's Business intelligent studio

hi ,

i have an excel sheet . i want to make  charts(bar/pie..etc) using Business intelligent studio of sql server 2005 .do i have to use SSIS ? or is there any other way ?

thanks in advance for help !