Share via

How to add a supercategory axis labels to a line chart?

Anonymous
2023-10-04T23:49:26+00:00

Hi, does anyone know how do I add a supercategory axis labels in excel? I would like to change the x-axis from showing as 2-Jan, 9-Jan, 16-Jan etc to 2nd, 9th, 16th with the month below these labels to 'group' these dates together.

Below is an example of how I would like to change the data

Current:

Below is the graph and data that I am working on.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2023-10-09T00:54:04+00:00

Use day only in your week column.

Was this answer helpful?

1 person found this answer helpful.
0 comments

10 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-10-06T02:26:37+00:00

    Move the month column, select the entire range C1:G40, Insert chart.

    Image

    .

    Add Quarter

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-10-05T16:32:24+00:00

    Hi Snow, here's the link to the file. Thanks so much.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-10-05T13:31:01+00:00

    Excel 365 Pro Plus with Power Pivot and Power Query.

    Weeks do not synchronize with months, quarters or years

    unless you adopt a 4-4-5 fiscal calendar.

    Here is an example:

    https://www.mediafire.com/file_premium/omhe03d2nkepva3/05_26_23.xlsx/file

    https://www.mediafire.com/file_premium/xmvorui85f2ws0j/05_26_23.pdf/file

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-10-05T02:46:00+00:00

    Could you share us a test file with some dummy data in it? It can be done with povit chart from povit tabel.

    Create a PivotChart - Microsoft Support

    For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

    Was this answer helpful?

    0 comments