Hi, i am doing Pivot chart for my report.
i have list of items which has been categorized.
is there a way to create a month range automatically? cause what ive done was i inserted text box manually to tag the range of category (ex: oct-feb 2022) - red circle
i really want to automate this cause its tiring to do it manually.
hope someone can help me.
THANKS IN ADVANCE!!!
this is my pivot table and chart (i did inserted the oct-feb manually)
this is my raw data
i have list of items which has been categorized.
is there a way to create a month range automatically? cause what ive done was i inserted text box manually to tag the range of category (ex: oct-feb 2022) - red circle
i really want to automate this cause its tiring to do it manually.
hope someone can help me.
THANKS IN ADVANCE!!!
this is my pivot table and chart (i did inserted the oct-feb manually)
this is my raw data