View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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!