Convert EXCEL file to Project Plan

When we have data in an EXCEL with number of dates, we can convert that data to Project Plan without any other software.

Got the excel magic from

http://chandoo.org/wp/2008/05/20/gantt-in-60-seconds-churn-out-an-excel-project-plan-in-no-time/

Chart WebPart With Excel Data

Add Chart Web-Part

Customize WebPart properties

Create Data Connection with EXCEL file

After Set Excel path and data Range,
Data will be shown in tabular manner

Customize data and show in 3D mode

Data in Excel on Charts :)

SharePoint Excel file throws unable to process the request when opens

 When we open an excel on browser,

 

We have to enable settings inside Library

Then we have to create Excel Service Application using Central Administration

 

Verify whether the Excel Service Application is configured using central administration

Now we can view Excel sheet through browser