Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    May 2004
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PivotChart Selections Missing (2007)

    In previous versions of Excel, pivotcharts displayed the page field selectors (think I have the right terminology) and the values selected. Excel 2007 does not appear to do this but instead uses a PivotChart Filter Pane.

    It WAS really nice to be able to see and print what selection was represented by the chart! Any suggestions for getting the selected value displayed on the chart?

    I'm hoping it's as easy as turning on an option but don't have my hopes up. All I can think of is custom vba code that modifies the chart title. (or reinstalling Office 2003!)

    Thanks in advance,

    Kevin

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: PivotChart Selections Missing (2007)

    Apparently, they were removed - see here, relevant portion quoted below:
    <blockquote><hr>PivotChart Filter Pane

    The PivotChart filter pane is a new task pane that enables you to filter PivotCharts. In previous versions, filters were accessed from buttons in the PivotChart, but removed these so they didn
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •