Change data Series from a bar to a line after changing axis

[Aaron]

I have a two y axis bar line pivot chart. The default put the data on the
wrong axises. I changed them to the proper axis, but how do I change them
from a bar to a line and vise versa? (right now the data I want as a bar is
a line and the data I want as a line is a bar)

 

[Jon Peltier]

You can select a series, then go to Chart menu > Chart Type, and select a
type that will be applied just to the selected series.

Next time, instead of using the inflexible built-in custom types, make your
own custom type. Make the chart as a column chart with all series, then
using the technique above change the ones you need to line, then double
click the ones you want to change to the other axis, and adjust the
selection on the Axis tab.

- Jon