![]() ![]() Specify URL which point to Trusted Location on your site. ![]() Check Pivot Chart and Table you want to publish in Web part.Ĥ0. In Show tab, click on Items in the Workbook.ģ8. This is useful feature by Excel, as we can get errors immediately (if any) in browser, rather than loading the Workbook in Web Part and then getting the result.ģ7. Note: Open in Excel Service check box should be checked, so after publish your Pivot Table and Chart is display in a browser. In Save As dialog box, click on Excel Service Options button.ģ6. Click on Workbook Ribbon (on top-left corner) -> Publish.ģ5. After preparing Pivot Chart and Table, you need to publish Workbook onto Sharepoint Trusted Location.ģ4. Click on PivotChart and Pivot Table Report option in Import Data dialog box.ģ3. Click on Connection name which we created above.ģ1. Click on Existing Connections in Data menu in your Excel Workbook.ģ0. Now, you can create your Chart based on your requirement.Ģ9. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |