+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Change date range in pivot table chart

  1. #1
    Registered User
    Join Date
    11-29-2010
    Location
    Belgium
    MS-Off Ver
    2010
    Posts
    87

    Change date range in pivot table chart

    Hi all,

    I have a workbook in which we are using a Pivot chart.

    However when I want to change the Chart Data Range when taking data from the Pivot table, all fields are grayed out and thus doesn't allow me to do so.

    Can you guys help me out here?

    In attachment you'll see a screen print of the dialogue box.

    rgds,
    Tino XXL
    Attached Files Attached Files
    Last edited by Tino XXL; 02-10-2011 at 11:41 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,772

    Re: Change date range in pivot table chart

    The pivot chart is linked to all the data in the pivot table.
    If you want to alter the dates shown you will need to alter the underlying pivot table and the rows/columns shown.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1