How to get 2 vertical axes?

[YEO]

Now im having 2 column charts:

1. Sales amount by department

and

2. Number of transactions by department

 

i wan to combine both of them in this way:

Sales amount : left vertical axis

Number of transactions: right vertical axis

department: horizontal axis

 

may i know can I achieve it?

thanks in advance

[Ivan Hristov]

Hi Yeo,

The graph item supports having more than one coordinate system exactly for such cases. In the current scenario the graph needs two coordinate systems with shared X axis that displays the departments. The first coordinate system will have an Y axis to display the sales amount, and the second coordinate system will have another Y axis to display the transactions number. The graph should have two series - one for each coordinate system. The position of the vertical axes is controlled by the CrossAxisPosition collection of the horizontal axis.  In other words, the horizontal axis defines where it will be crossed by the other axes.

The process is described in the How To: Add a Secondary Axis article, but I decided to shoot and attach video based on your requirements, that shows how easy actually is to create a Graph item with two Y axes from scratch. Please check the video and let us know if you need further assistance.

Regards,
Ivan Hristov
Progress Telerik