Follow Us:
On a recent project I got to work with the out-of-the-box (OOTB) Chart Web Part in SharePoint 2010. My team just needed to chart some simple data, nothing fancy, but we had some fairly specific styling requirements. We tried Web parts from other vendors they already had and got close, but we just couldn’t get there. Luckily we were upgrading to Enterprise anyway, so that allowed us to use the Chart Web Part that comes with SharePoint OOTB. Unfortunately (depending on your point of view), this Web part has been removed from SharePoint 2013. You can find all of the deprecated features listed here. Microsoft’s vision for BI and reporting is shifting more to Excel Services: “Similar features can be used with other applications, such as Excel Services.”
Fortunately, we were using SharePoint 2010 in this environment. In working through getting it configured with all the styling I needed, I wanted to share a couple quick and easy tips regarding this powerful little Web part.
I configured this Web part in a development environment, and after I spent a good amount of time setting all the various hidden advanced properties for this Web part, I wanted to move this to the production environment. When you go to edit the Web part and look for the export option, it’s not there.
We can easily add it back. I believe there are a few Web parts that won’t work if you export them, but luckily this one does. So edit the Web part properties, and under Advanced, look for "Export Mode" as shown below.
Change this to “Export all data” and click OK. Now you can export the Web part and import it to your other environment.
This Web part was going to be on the intranet home page, not interactive, and sit in a small fixed sized box, so there was no need for the toolbar. There are already a few documented ways to remove it, either by editing the Web part in SharePoint Designer (my page was based on a page layout, so no help there), or by using Javascript / JQuery (I wanted a no-code solution). I used CSS to do this, it’s quick and easy.
Using either IE F12 or Firefox Firebug, find the parent table that has the class of ms-menutoolbar. That’s the guy we want. That is the toolbar in Web parts that shows up like it used to in 2007.
If there are no other Web parts on the page that use the toolbar, you can add this CSS:
.ms-menutoolbar {display:none;}
Depending on where you use it, you might have to wrap it in a style tag, use a content editor Web part, or create a CSS file. If you want to target the Web part only, then we need to make one change. In the screenshot above, notice the id tag on the div class ms-WPBody. That is the main ID of the Web part that you can reference in CSS that we can use to make the change in this Web part only:
#WebPartctl100_m_g_23f423ee_7312_4ae9_a1d5_ee3810495710 table.ms-menutoolbar {display: none;}
Voila–no toolbar! If you would like more information on C5 Insight or this blog content, fill out our Contact form.
The change (hide display) is only lasts until I reload. How can I make it lasting?
EB, how are you hiding the toolbar? Did it only work once then never again? Sounds like maybe you didn't publish the page, or something wrong with the content editor? Doug
(depending on your point of view), this Web part has been removed from SharePoint 2013 >> Doug, what do you suggest is the best way to do charting in SP 2013? I was looking at http://www.collabion.com, which seems like a good option. Do you have any suggestions?
Twain, The MS answer is to use Excel and its new visualization engine Power View with Excel services / Excel App, but there are of course other 3rd-party web parts available from cheap and simple like Amrein to way cool and pricey, but it depends on on-premise or online, requirements, etc. You just need to evaluate each product to see if it fits your business requirements. What data do you need to chart? SP lists or external business data? SQL reports? Do you just need simple charts, or do you need the ability to completely customize the styling of your chart? There is no perfect answer, you just need to find one that works for you. Hope it helps! Doug
Really Good tips
The complementary paper includes over 12 years of research, recent survey results, and CRM turnaround success stories.
Request Download
This 60-second assessment is designed to evaluate your organization's collaboration readiness.
Learn how you rank compared to organizations typically in years 1 to 5 of implementation - and which areas to focus on to improve.
This is a sandbox solution which can be activated per site collection to allow you to easily collect feedback from users into a custom Feedback list.
Whether you are upgrading to SharePoint Online, 2010, 2013 or the latest 2016, this checklist contains everything you need to know for a successful transition.