I'm getting crazy, I have a google sheet with...

I’m getting crazy, I have a google sheet with the first column as date, formatted as Number

Date I have another column with a number of product sold. I’m just doing a chart (histogram with Group aggregated "product old) or Aggregated

donuts I Always get a chart with every single date on x axis, I want it aggregated by date by month, not every single date I have in the sheet. I review my date data and look ok to me. in the google sheet date and #Sm sold are the 2 main data to plot.

Please any input ?

0 1 312
1 REPLY 1

Add a virtual column Month with app formula MONTH([DateColumn])

Then set up your histogram chart to pick the Month column.

Top Labels in this Space