Y- Axis control in combo chart

[jsutherl]

HI!

I made a line and clustered column chart. I have 4 sets of data. 2 sets are dollar amounts I need on the secondary y axis as lines. On the other axis, i need a column and a line. I can't figure out how to assign the value of the line to the same axis as the column. Any ideas?

[Uzi2019]

hi @jsutherl 
Whatever data you want it on (Bar) put it on column Y axis. and for line you need to add data to the line Y axis.

If my solution helps please give kudos and accept it as a solution!
Thanks

[amitchandak · Accepted solution]

@jsutherl , Both Lines can on the Primary Y-axis or both can be on the secondary y-axis. As of now, you can not have one line on primary and one on secondary in case of line and clustered column chart

When you disable secondary y-axis, the lines will move to primary