Specifying Data Use 
Exactly which data is displayed in the business graphic depends primarily on whether and in which columns of the list you make calculations:
If you do not make any calculations:
The first column with an alphanumeric data type is used for the axis that contains the characteristics of the chart.
In vertical bar charts, this is usually the X axis; in bar charts, this is usually the Y axis.
The first column with a numeric data type is used for the axis that contains the key figures of the chart.
In vertical bar charts, this is usually the Y axis; in bar charts, this is usually the X axis.
If you make calculations:
The first column with an alphanumeric data type is used for the axis that contains the characteristics of the chart.
Each column that involves a calculation is displayed in the axis that contains the key figures for the chart.
If you generate intermediate results:
Each column that is a criterion for intermediate results is displayed in the axis that contains the characteristics for the chart. If you specified more than one criterion, the combination of the criteria is displayed.
Each column that involves a calculation is displayed in the axis that contains the key figures for the chart.
Procedure
Move the columns that contain the data for a business graphic to the front.
If necessary, execute calculations to display additional data in the business graphic.
If required, reduce the number of elements in the business graphic by creating intermediate results.