displaying the months on a graph by fiscal year not calendar year

  • Thread starter Thread starter SMT
  • Start date Start date
S

SMT

I have a query in which I have included the tblmonth, which has a number and
its corresponding month according to fiscal year...i.e.,
Month, MonthID
October, 1
Novemer, 2
December, 3 and so on.

I am creating chart off of this query and need the chart to show display the
actual month but sort it in the order of MonthID. For example my graph has
the months listed at the bottom but they go in alpha order versus fiscal year
order which is what I need. How can I correct this so the graph will display
the appropriate month in its appropriate order?
 
Back
Top