Changing chart types with series

[miteeka]

Hi,

I currently have a graph comprised of 4 different series. 2 of the series
are bar graphs, 2 others are line graphs. The problem is that one of the bar
graphs is overtop of the other bar graph meaning I can't see that series.
I've tried going in and changing it by changing the overlapped bar graph to a
line graph but I can't seem to do it. I've right clicked, selected chart
types but I can't change only 1 series of the graph. Is there anyway to do
this? Thanks,

 

[Jon Peltier]

Sounds like one column is on the primary and the other is on the secondary
axis. You need some dummy column series that are hidden but still take up
space to push the visible columns into alignment:

http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

- Jon

 

[miteeka]

But how do I automatically turn the second bar graph into a line graph? This
will give me 1 bar graph and 3 line graphs in total. Thanks,

 

[Jon Peltier]

Don't use the built in custom type. Make the chart with all of one type,
like columns, then select one series, and use Chart menu > Chart Type to
change it to another type, like line.

- Jon