kwizcom banner advertisement

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
<webParts>
  <webPart xmlns="http://schemas.microsoft.com/WebPart/v3">
    <metaData>
      <type name="Microsoft.Office.Server.WebControls.ChartWebPart, Microsoft.Office.Server.Chart, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
      <importErrorMessage>Cannot import Chart Web Part.</importErrorMessage>
    </metaData>
    <data>
      <properties>
        <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&gt;
    &lt;Series Name="Default" ShadowOffset="2" ChartArea="Default" BorderColor="26, 59, 105"&gt;
    &lt;/Series&gt;
  &lt;/Series&gt;
  &lt;ChartAreas&gt;
    &lt;ChartArea BackColor="White" ShadowOffset="2" BorderColor="26, 59, 105" BorderDashStyle="Solid" Name="Default"&gt;
      &lt;AxisY&gt;
        &lt;MajorGrid LineColor="Silver" /&gt;
        &lt;MinorGrid LineColor="Silver" /&gt;
      &lt;/AxisY&gt;
      &lt;AxisX&gt;
        &lt;MajorGrid LineColor="Silver" /&gt;
        &lt;MinorGrid LineColor="Silver" /&gt;
      &lt;/AxisX&gt;
      &lt;AxisX2&gt;
        &lt;MajorGrid LineColor="Silver" /&gt;
        &lt;MinorGrid LineColor="Silver" /&gt;
      &lt;/AxisX2&gt;
      &lt;AxisY2&gt;
        &lt;MajorGrid LineColor="Silver" /&gt;
        &lt;MinorGrid LineColor="Silver" /&gt;
      &lt;/AxisY2&gt;
    &lt;/ChartArea&gt;
  &lt;/ChartAreas&gt;
  &lt;BorderSkin BackColor="CornflowerBlue" BackSecondaryColor="CornflowerBlue" /&gt;
&lt;/Chart&gt;</property>
        <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=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">BrightPastel</property>
      </properties>
    </data>
  </webPart>
</webParts>
Or you can download it directly from : Download Chart Web Part , 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 2016 and SharePoint Online too!
How to Enable Chart Web Part in SharePoint 2013? How to Enable Chart Web Part in SharePoint 2013? Reviewed by Salaudeen Rajack on 7:26 PM Rating: 5

22 comments:

  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?
    Thanks,
    Bryan

    ReplyDelete
  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?

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

    ReplyDelete
  4. This is awesome! Thanks Mr Salaudeen!

    ReplyDelete
  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.

    ReplyDelete
  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?

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

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

    ReplyDelete
  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.

    ReplyDelete
  10. Guys to make this work you need to modify the 3 "xmlns" values. Shorten them to ONLY the URL, and delete all the HTML tags like "a" and "span" etc. They're on lines 2 and 56.

    ReplyDelete
    Replies
    1. Give an example please

      Delete
    2. Line 2:

      Line 56: <?xml version="1.0" encoding="utf-16"?>
      <ArrayOfDataBinding xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />

      Delete
  11. I just copied the text into a .txt file and it worked first time.

    ReplyDelete
    Replies
    1. Did you save as a webpart file after copying into a .txt file? This is where I am stumped. I can't save it as a webpart file.

      Delete
    2. Did you do anything special to save as a webpart file from the .txt file?

      Delete
  12. You can download the webpart from here: https://goo.gl/1pyqNb

    ReplyDelete
  13. Wooowww. Great help Bro!! serves the Purpose!!

    ReplyDelete
  14. I have created a list with 3 columns, title , count (default value is 1) and status as "open" & "resolved".
    i have set the Y field as count, x field as status and group by field as count
    suppose i have 3 entries with two line item with status as resolved and one as open then the graph that i see is 3 columns on x axis as "resolved" resolved & open" and on y axis it show bar to 1 unit. Please help me find out how do i get the correct graph. Do you have any documentation to refer ?

    ReplyDelete
  15. successfully connected my list, how do I filter for created & last 30 days? what would be appropriate default value?

    ReplyDelete

Please Login and comment to get your questions answered!

Powered by Blogger.