+ Reply to Thread
Results 1 to 2 of 2

how to create sub group in data table

  1. #1
    Registered User
    Join Date
    05-11-2023
    Location
    Canada
    MS-Off Ver
    online
    Posts
    1

    Question how to create sub group in data table

    I would like to know how to add the "year" to my graph data table. Table shows months but not the year for some reason.
    See picture attached.

    Thanks a lot
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,647

    Re: how to create sub group in data table

    Hello jpaulphan and Welcome to Excel Forum.
    My suspicion is that this is related to using an online version because years and months can be displayed in a data table using a desktop version.
    In the attached file there is a chart with a data table for a regular table and for a pivot table.
    It may also be related to using an online version that causes the months from 2023 to not display in the data table shown in the screenshot.
    Sorry not to be of more help.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Given a table of groups and members, create a table of unique members and group membership
    By mdwilson1991 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-23-2020, 08:38 AM
  2. Replies: 3
    Last Post: 01-30-2018, 07:26 PM
  3. Group by date and create new field in Pivot Table
    By Smally in forum Excel General
    Replies: 2
    Last Post: 08-10-2015, 07:55 AM
  4. [SOLVED] Create Pivot Table with group dates; summarize values by average; h:mm
    By 3345james in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-24-2015, 10:59 AM
  5. [SOLVED] Create formula to group insurances when there are multiple rows of data.
    By tmk230207 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-20-2014, 02:11 PM
  6. [SOLVED] Group together and add up data from table?
    By Ben1985 in forum Excel General
    Replies: 8
    Last Post: 01-09-2014, 04:20 PM
  7. how to create group in pivot table data
    By ganeshadeshpande in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2013, 04:33 AM

Tags for this Thread

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