Create combo chart 2007
 

I now have Excel 2007 and what used to be easy is not so in many cases. One
of these cases is the creation of a combo chart - a set of 3 columns that are
represented by bars and 1 column represented by a line with a seperate axis.
I know I've done it before, I think they were even 3D bars, but now when I
try to change the series it changes the whole chart. HELP!

Create combo chart 2007
 

Hi,

To change the chart type you need to select as single series first.

If it's a 3d type then you are, and always have been, out of luck. 3d
types do not do combinations.

Cheers
Andy

Johnny G wrote:
I now have Excel 2007 and what used to be easy is not so in many cases. One
of these cases is the creation of a combo chart - a set of 3 columns that are
represented by bars and 1 column represented by a line with a seperate axis.
I know I've done it before, I think they were even 3D bars, but now when I
try to change the series it changes the whole chart. HELP!

Create combo chart 2007
 

And I was blaming 2007... Sorry, my bad. Thanks Andy

"Andy Pope" wrote:

Hi,

To change the chart type you need to select as single series first.

If it's a 3d type then you are, and always have been, out of luck. 3d
types do not do combinations.

Cheers
Andy

Johnny G wrote:
I now have Excel 2007 and what used to be easy is not so in many cases. One
of these cases is the creation of a combo chart - a set of 3 columns that are
represented by bars and 1 column represented by a line with a seperate axis.
I know I've done it before, I think they were even 3D bars, but now when I
try to change the series it changes the whole chart. HELP!