Now i select two fields A and B , it default set A as x-axis and B as y-axis. But now i want set B as x-axis and A as y-axis . How to set it? Thanks in advance! Because it is based third system. So i can't use timechart or chart.
You can see partially the solution you are looking for clicking on the following link:
http://coverall.splunk.com/web_assets/education/splunk101/43/ReportsDashboards/index.htm
My search is select some field from oracle. just like this "|**.py select A,B from tablename"
You probably have something like this in your current search, right?
{other search criteria} | chart sum(B) over A
Reverse A & B, that should do it. Refer to the online manual at http://docs.splunk.com/Documentation/Splunk/latest/User/VizDataStructures for additional info.