headermask image

Business Tools Blog

Hide the field buttons in a Pivot Chart

Once you’ve created a pivot table, you can right click on the pivot table to quickly create a pivot chart.

Photobucket

The problem is that a pivot chart has those ugly field buttons.  Microsoft put them in the charts, so that the user can easily re-arrange data, but when the chart is finished, the field buttons make your chart look sloppy. 

Photobucket

I  only recently and quite by accident discovered that you can hide these buttons.  Right click on any filed button and then select Hide Pivot Chart Field Buttons.

Photobucket 

Your chart now looks like this:

Photobucket

 

 

If you liked my post, feel free to subscribe to my rss feeds

Money Making Options

Post meta

This entry was written by Sandi Mays and posted on July 10, 2008 at 12:40 am and filed under Excel. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment(Latest is displayed first) or leave a trackback: Trackback URL.

Share with others

Post Hide the field buttons in a Pivot Chart to digg. Post Hide the field buttons in a Pivot Chart to Reddit add to stumbleupon Google Bookmark myweb bookmark on del.cio.us newsvine Tailrank magnolia Furl co.mments shadows simpy blinklist

4 Comments so far (Add 1 more)

  1. I love you for this. No, really.

    1. brn on August 17th, 2009 at 1:27 pm

  2. Hi Jen,

    The example shown above is in 2003. Just right click on the button that you want to hide and click “Hide Pivot Chart Field” on the menu.

    2. Sandi Mays on September 9th, 2008 at 3:59 pm

  3. Great do you know how to hide on the pivot table in excel 2003?

    3. Jen on September 9th, 2008 at 3:53 pm

  4. Haha, Some people have called me an Excel expert but this one I didn’t know.

    Thanks for sharing.

    4. Joprotus on August 20th, 2008 at 3:52 am

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*