Forum Discussion

JCBI1023's avatar
JCBI1023
Icon for Helper III rankHelper III
8 years ago
Solved

Clustered Column Chart - Axis Help (with pictures)

Hello!   I am working with the Clustered Column Chart to compare FY Month GP.  Our FY goes from October to November. I created a Fiscal Year Calendar table that looks like this. And I am sorting al...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Could you try putting your fiscal month number column in the axis field above your FiscalYYYY-MM field. This should then group and sort first on month number and then by the dates.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Could you try putting your fiscal month number column in the axis field above your FiscalYYYY-MM field. This should then group and sort first on month number and then by the dates.

JCBI1023's avatar
JCBI1023
Icon for Helper III rankHelper III
8 years ago

That works! Now how do I show Nov-17/Nov-18 as opposed to 1, etc.