Bars and lines, how do I specify which?

[nickbarthram]

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

[tuph]

Click on one of the bars or lines, then right click and select Chart Type. You should be able to change it, but I'm not sure whether the change will be reset when you refresh the pivot chart.