图例及提示的显示顺序是由数据源的顺序而定,直接在图表的SQL数据集中修改指定系列顺序排序即可
mysql自定义排序:
SELECT * FROM A ORDER BY FIELD(name, '王五', '张三', '李四') ASC
sql server自定义排序
elect name from fruit
order by case name
when 'Strawberry' then 1
when 'Banana' then 2
when 'Apple' then 3
else 4end
oracel自定义排序:
select * from table_date
order by
decode(DateStr,
'Monday',1
'Tuesday',2
'Wednesday',3
'Thursday',4
'Friday',5
'Saturday',6
'Sunday',7,
0);