I tested out the column/line chart in a 1X/2Y scenario.  I created KPI data 
where 1st Y = number, and 2Y = %.  My goal was to have the 1st Y as columns and 
2nd Y as lines.  When I created the table with the wizard, it only selected the 
last data element to become the line.  I manually associated it to a second Y 
axis, which generated normally.  However, when I associated another % data 
element to the second Y axis, it changed the reference for the column to the 
second axis, but didn't convert it into a line.  

I was impressed with the ability to create regression on any data element; and 
the other data element options. Good job!

Recommendations:
1. Revise the wizard to allow creation of second Y axis during chart set up.
2. Add an option in the data series object properties> Options tab > "Align 
data series" section to select either line or bar when second Y axis is 
selected.  Example: Data may be mixed in the table, and may want to manually 
related it to the second Y axis.