I based my example on the database Northwind using the tables Orders and Order_details . I created a formula field Revenue : {Order_Details.Quantity}*{Order_Details.UnitPrice} and another one Monthname : monthname(month({Orders.OrderDate}), true) Based on those two formula fields I created the graph which then looks like this: The problem is, it is then sorted on mont name in an alphabetical order (the month names are in Dutch by the way). The way I found to solve this problem is this. Go tot the Chart Expert: Click Monthname . Click Order . Choose In specified order . Now, fill in all the names of the months like this. Then click Others . Click Discard all others . Click OK twice. Your graph will then end up like this, with the month names in the right order:
Blog over software als Access, Excel, SQL, Crystal Reports, Report Builder, Word, VBA, elfstedentochten en andere regionale zaken.