Line/Bar combo chart: issues

[martinbarnes]

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

 

[Andy Pope]

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