I want single line chart, with dual y axis; i.e. each point of line have two values for both y axis.
ex. in below chart, consider all points connected as line. approx values. (for simplicity did, y2 value = 2 * y1, actual values are different.)
Point 1 refer as Month=Jan, Qty=20, Amount=40K Point 2 refer as Month=Feb, Qty=18, Amount=36K Point 3 refer as Month=Mar, Qty=13, Amount=26K Point 4 refer as Month=Apr, Qty=22, Amount=44K Point 5 refer as Month=May, Qty=16, Amount=32K
single line chart with dual y axis
in General usage
Posted · Report reply
I want single line chart, with dual y axis; i.e. each point of line have two values for both y axis.
ex. in below chart, consider all points connected as line.
approx values. (for simplicity did, y2 value = 2 * y1, actual values are different.)
Point 1 refer as Month=Jan, Qty=20, Amount=40K
Point 2 refer as Month=Feb, Qty=18, Amount=36K
Point 3 refer as Month=Mar, Qty=13, Amount=26K
Point 4 refer as Month=Apr, Qty=22, Amount=44K
Point 5 refer as Month=May, Qty=16, Amount=32K
35|______________________________________________________________|70K
|_________________*_____________________________________________|
30|_______________________________________________________________|60K
|_______________________________________________________________|
25|_______________________________________________________________|50K
|_______________________________________________________________|
20|___*_________________________________________*__________________|40K
|_______________________________________________________________|
15|___________________________________________________________*___|30K
|_______________________________*_______________________________|
10|_______________________________________________________________|20K
|_______________________________________________________________|
5|_______________________________________________________________|10K
|_______________________________________________________________|
Qty------Jan----------Feb------------------Mar---------------------Apr---------------May----Amount
How can i achieve same?