79751404

Date: 2025-08-30 20:40:31
Score: 1
Natty:
Report link

heyy so, Excel doesn’t have a built-in “quarter” number format, so typing qq-yy will always just show “qq” as text. To display quarters on your axis, you’ll need to either (1) create a helper column in your data with a formula like ="Q"&ROUNDUP(MONTH(A2)/3,0)&"-"&TEXT(A2,"yy") and use that as your axis labels, or (2) group the dates by quarter if you’re using a PivotChart. Simply changing the number format won’t work because quarters aren’t a supported date format code.

Reasons:
  • Has code block (-0.5):
  • Single line (0.5):
  • Low reputation (1):
Posted by: Nkosiyapha Khanyi