Localizing Legends in Crystal Reports

To localize the legends in my Crystal Reports Graphs I had effectively change my SQL "select statements" at runtime to incorporate column aliases.

For example, my original sql statement looks like this

SELECT `Copy_of_ivv`.`Trading_Date`, `Copy_of_ivv`.`High`, `Copy_of_ivv`.`Low`
 FROM   `Copy of ivv`

To get the legends to display in chinese, you have to alias the columns returned which appears to drive the legend names

 SELECT `Copy_of_ivv`.`Trading_Date` as '交易日', `Copy_of_ivv`.`High` as '高', `Copy_of_ivv`.`Low` as '低'
 FROM   `Copy of ivv`