so in now rereading your initial response, you're saying that I don't even
have to pick the custom charts when selecting to change each column? I can
literally pick each column and say that I want it to be a line, and Excel
will keep the other columns intact?
--
Boris


"Andy Pope" wrote:

Firstly, thanks for the comments.

With column and line it is possible to have both chart types on both
sets of axes. So you will need to change both the chart and axis type of
the series.

Cheers
Andy

BorisS wrote:
Very impressive stuff on your site. Hats off. I've seen some others, but
this is a cut above.

Thanks for the tips on selecting secondary axis as well.

Not sure if it's a related question, but actually choosing which type of
charting happens for a particular series (as in, if I have, let's say, three
lines that I want and 2 bars). Possible? How do I tell Excel which series
goes with which type, or is it simply that if I have two axes, and one
corresponds to columns and the other to lines, then by telling something that
is initially a column to be on the secondary axis, it'll just switch to a
line because it'll then be on the secondary axis?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info