PDA

View Full Version : Steps To Import Your Graphs in SharePoint



Portal88
06-19-2013, 04:03 AM
SharePoint is a Web application software by Microsoft used for creating and managing intranet and Internet websites. Use this collaboration technology to manage content, search and sharing documents for small and large organizations using the "ribbon-like" interface. It has multiple built-in features to create custom Web parts, lists, libraries, meeting work spaces and imported and exported documents from Microsoft Office, along with custom sites for discussion boards, blogs, surveys and announcements. You can import graphs and display them in SharePoint using Excel Services --- a part of Microsoft Office SharePoint Server popularly known as MOSS.

Instructions

1. Click "Star,t" and navigate to the "Central Administration." Click "Operations," and select "Services on Server." Search for a service by the name of "Excel Calculation Service," and check whether is running. In case it is not running, right-click the services icon and select "Start Service" from the menu to run the service.

2. Click "Site Actions," and select "Create" from the available options. Click "Document Library" from the list of templates. Define a "Trusted File Location" --- a type of SharePoint Document Library used by Excel Services to open the Excel files.

3. Click "Shared Services Administration Site," and select "Excel Services Settings." Click "Trusted File Locations" to select it from the available options. Specify the full path of the document library where you will store all the Excel files under "Address." Click "Windows SharePoint Services" for "Location Type," then click "OK" to go back to the original screen.

4. Click "Start," and select "All Programs." Click "Microsoft Office," then click "Microsoft Excel" from the available applications. Click "File" to open an excel file you want to import into SharePoint.

5. Create a chart by clicking "Insert" from the menu and selecting from the available types of charts. Click the "Windows Office" button, click "Publish," then click"Excel Services" to open a "Save As" screen.

6. Navigate to the document library where you want to store the Excel file, then click "Open in Excel Services" to open the Excel sheet in a Web browser. You can specify more options such as displaying only selected range, items and parameters by clicking "Excel Services Options." Select the option "Items in the Workbook," click the chart you want to display to select it from the "Show" tab and click "OK" to save the spreadsheet in your document library.

7. Open your SharePoint site, click "Site Actions," then click "Edit Page" to open the page in the editing mode. Click the "Insert" tab, and select "Web Part" to open the list of custom-built Web parts. Search and select "Excel Web Access" to add it to your page. Click "Tool" tab to open "Excel Web Access" screen to configure properties for displaying a graph. Select your file under Workbook by clicking "..." under "Workbook," then enter the name of the graph under "Names Item." Specify other properties such as "Rows" and "Columns," then click "OK" to initiate rendering of the graph.