+ Reply to Thread
Results 1 to 2 of 2

A simple pivot chart doubt

  1. #1
    Registered User
    Join Date
    10-28-2012
    Location
    Napier
    MS-Off Ver
    Excel 2010
    Posts
    1

    A simple pivot chart doubt

    Hi Everybody,

    I am using EXCEL 2010 in my system and I am working on some sales data. In view of the large data, I wanted to group my timelines with months instead of dates. So, I went into PIVOT TABLE TOOLS in the menu, selected OPTIONS to use the GROUP FIELD function, but the GROUP FIELD function is disabled in my Excel 2010. I am unable to activate/enable this GROUP FIELD function .

    I would really appreciate if folks here can let me know on how to enable/activate the GROUP FIELD function.

    Thanks and Cheers.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: A simple pivot chart doubt

    is your data really stored as actual dates and not text? is it stored in the workbook or coming from an external system?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ 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