View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Line/Bar combo chart: issues

Hi,

Ignore the built-in combination types and instead roll your own.
Create a column chart based on all 4 data series.
Select the series to be plotted as line chart.
Right click and choose Chart Type. Select Line Chart.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"martinbarnes" wrote in message
...
If anyone can hepk me out with this:

I have 4 series of data that I'm trying to graph, 3 series as a bar graph
and one as a line, on the same chart. The custom bar-lin chart
automatically
splits the series into pairs (i.e. it graphs 2 series as bar graphs and
the
other 2 series as lines). How do i change this so that i can have 3
bars/1
line?

marty