Chart web part – pesky toolbars

When you add a chart web part to a page, you’re left with the ‘Data & Appearance’ and ‘Advanced Properties’ toolbar links. Unfortunately, they can’t be hidden through the web part configuration user interface.

1. Open the ASPX page in Designer.
2. Use Code View and find the web part.
3. Edit the ShowToolbar property from ‘True’ to ‘False’.
4. Save changes.

The links are hidden – the web part drop down still shows them and allows access to use them without reseting the ShowToolbar property.

Chart web part… with counts

or, how to use the OOTB chart web part to show how many list items have a certain column value. It can be done, but only by using a lookup column for the values.

1. Create a lookup list with the values requried.
2. In the list that’s going to hold the values, add a lookup column getting the information from the lookup list.
3. Then, back in the lookup list, add a new column there (let’s call it ‘Count’…) and make that a lookup column to the list & column that’s the lookup to this column – it’ll show up in the ‘In this column:’ dropdown with ‘(Count Related)’ suffixed.

Now, on the lookup list there’s the values and the count of their usage. Point the chart web part at this list and it’ll show the values and counts. Obvious…