Share via

Rolling 12 month Chart

Anonymous
2022-01-12T14:28:26+00:00

I have charts for all of 2021, it has been decided that we would like to keep a rolling 12 month view for 2022. For example, we want to drop January 2021 and include January 2022. This data would appear after December 2021, etc..

How can I modify charts to accomplish this?

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

  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2022-01-12T14:46:29+00:00

    That is not up to the charts, is up to your data.

    A simple way is to setup the chart to show all time data, then simply filter out the data you don't want to see in the chart.

    But in the sense of data analyzing this means use a Pivot table / chart to analyze the data and apply a Timeline.

    https://support.microsoft.com/en-us/office/create-a-pivottable-timeline-to-filter-dates-d3956083-01be-408c-906d-6fc99d9fadfa

    Andreas.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-01-12T15:00:51+00:00

    Thank you, worked perfectly.

    Was this answer helpful?

    0 comments