Tuesday, June 17, 2014

How to Enable Chart Web Part in SharePoint 2013

As per Microsoft, Chart web part in SharePoint 2013 has been discontinued, So, chart web part will be missing! Of course there are many 3rd party products available to bring Chart functionality in SharePoint 2013, is it possible to resurrect the same old chart Web part in SharePoint 2013? Yes! We can!! Here is how to enable chart web part in SharePoint 2013:

Disclaimer: I'm not sure this is a fully supported method, but it serves the purpose!
Step 1: Save this below chunk as a "Chart.Webpart" file
  <webPart xmlns="http://schemas.microsoft.com/WebPart/v3">
      <type name="Microsoft.Office.Server.WebControls.ChartWebPart, Microsoft.Office.Server.Chart, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
      <importErrorMessage>Cannot import Chart Web Part.</importErrorMessage>
        <property name="RealTimeInterval" type="int">0</property>
        <property name="Height" type="unit" />
        <property name="IsCustomized" type="bool">False</property>
        <property name="ListUrl" type="string" null="true" />
        <property name="AllowConnect" type="bool">True</property>
        <property name="CatalogIconImageUrl" type="string" />
        <property name="Title" type="string">Chart Web Part</property>
        <property name="Hidden" type="bool">False</property>
        <property name="ShowDebugInfoRuntime" type="bool">False</property>
        <property name="BindToDataDesignMode" type="bool">True</property>
        <property name="TitleIconImageUrl" type="string" />
        <property name="ChromeState" type="chromestate">Normal</property>
        <property name="Description" type="string">Helps you to visualize your data on SharePoint sites and portals.</property>
        <property name="ChartXml" type="string">&lt;?xml version="1.0" encoding="utf-16"?&gt;
&lt;Chart BorderColor="26, 59, 105" BorderWidth="1" BorderlineDashStyle="Solid"&gt;
    &lt;Series Name="Default" ShadowOffset="2" ChartArea="Default" BorderColor="26, 59, 105"&gt;
    &lt;ChartArea BackColor="White" ShadowOffset="2" BorderColor="26, 59, 105" BorderDashStyle="Solid" Name="Default"&gt;
        &lt;MajorGrid LineColor="Silver" /&gt;
        &lt;MinorGrid LineColor="Silver" /&gt;
        &lt;MajorGrid LineColor="Silver" /&gt;
        &lt;MinorGrid LineColor="Silver" /&gt;
        &lt;MajorGrid LineColor="Silver" /&gt;
        &lt;MinorGrid LineColor="Silver" /&gt;
        &lt;MajorGrid LineColor="Silver" /&gt;
        &lt;MinorGrid LineColor="Silver" /&gt;
  &lt;BorderSkin BackColor="CornflowerBlue" BackSecondaryColor="CornflowerBlue" /&gt;
        <property name="WorkBookUrl" type="string" null="true" />
        <property name="AllowMinimize" type="bool">True</property>
        <property name="ChromeType" type="chrometype">Default</property>
        <property name="AlignDataPointsByAxisLabel" type="bool">False</property>
        <property name="AllowZoneChange" type="bool">True</property>
        <property name="DataBindingsString" type="string">&lt;?xml version="1.0" encoding="utf-16"?&gt;
&lt;ArrayOfDataBinding xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" /&gt;</property>
        <property name="ShowToolbar" type="bool">True</property>
        <property name="Width" type="unit" />
        <property name="HelpMode" type="helpmode">Navigate</property>
        <property name="TitleUrl" type="string" />
        <property name="DesignerTemplateId" type="string" />
        <property name="HelpUrl" type="string" />
        <property name="ExportMode" type="exportmode">All</property>
        <property name="ConnectionPointEnabled" type="bool">True</property>
        <property name="AllowClose" type="bool">True</property>
        <property name="AllowEdit" type="bool">True</property>
        <property name="Direction" type="direction">NotSet</property>
        <property name="AllowHide" type="bool">True</property>
        <property name="DesignerChartTheme" type="Microsoft.Office.Server.Internal.Charting.Utilities.ChartTheme, Microsoft.Office.Server.Chart, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c">BrightPastel</property>
BTW, I exported this from SharePoint 2010!

Step 2: Upload the web part to Web parts gallery:
Next step is to enable chart web part in SharePoint 2013.
  • Go to Site Settings >> Click on "Web Parts" link under "Web Designer Galleries" section.
  • On the "Files" tab, Click on "Upload Document"
  • Locate the "Chart.webpart" file and specify web part attributes.
how to enable chart web part in sharepoint 2013

Step 3: Add chart web part to SharePoint 2013 page:
So, now we have the web part ready! Navigate to any page where you want to add chart web part, Click on "Web Part" from "Insert" tab, Choose "Chart Web Part" and click "OK".
chart web part in sharepoint 2013
Configure Data connections and other properties of the chart, and here is the output:
how to create chart web part in sharepoint 2013
This chart web part also works in SharePoint online 2013!

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.

Check out these SharePoint products:


  1. Hi Salaudeen, this looks promising but when I copy and try and use I get a poorly formed xml error. Can you post the actual file for download?

  2. I also get an error about XML not correct. I pasted the code into Notepad and get all lines intersected with blank lines, but that couldn't cause the problem, could it?

  3. HI, i importet web part no problewm,buti got problem that anything that i click i get error something went wrong.

  4. This is awesome! Thanks Mr Salaudeen!

  5. Hi, When i tried in sharepoint online, I got error message like "The file you imported is not valid. Verify that the file is web part description file(*.webpart or *.dwp) and that contains proper xml file"

    But i tried with .webpart and .dwp. still getting the same error.

  6. I'm getting the same poorly formed xml error mentioned above. I pasted the xml into a xml checker online, and it said it was valid. Anyone know what is going on here?

  7. After configuring chart webpart data connection nothing comes up. It always shows blank page. Any idea?

  8. Trying to use code but get the not well formed xml. Any ideas?

  9. Hey! Worked a treat for me - opened in xml editor, pasted data as above and saveas xml type and given the name "Chart.Webpart" - Upload to SP2013 and loaded onto a page and worked. Great! thanks.


Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...