Thread: Bars and lines, how do I specify which?

Hi

I've got a pivot-chart set up that is reading four columns of data. What I would like to do is to make three of the columns of data appear as lines reading from the secondary Y-axis, the forth column of data should appear as a bar attached to the primary Y-axis.

I can make the columns of data attach to the relevant axes, but Excel assigns two of them to lines and two to bars, how do I change this?

Any help much appreciated

Kind regards

Nick