View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default include more than 3 data series as columns in combination chart

On Tue, 26 Jun 2007, in microsoft.public.excel.charting,
Cindy said:
I am making a combination chart and am only able to include the first 3 data
series with the column chart part. The rest of the series are all included
with the second series which has a much larger value.


Ignore "combination" charts, you don't need the hassle. They rarely
provide the solution you want. Just go in, click on the series that are
inappropriately lines, right click and select "Chart type", and turn
them into the columns you want.

The basic thing to remember is that "Chart type" belongs to each series
separately; you don't have to find a chart in the menu that's two
columns and three lines, or four areas and a scatter series. You can
just make each series a column or a line as you wish.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.