Problems creating Line-Column chart (Excel 2000)

  • Thread starter Thread starter Trell
  • Start date Start date
T

Trell

I am attempting to create a chart with 5 series (2 bars and 3 lines) but it
seems that the chart can only be created with 2 lines. Is there some way of
changing one of the bar series to a line series? I have tried right
clicking on one of the bar series and changing the chart type, but then one
of my other line series converts to bars instead.

TIA,
Reid
 
Hi Reid,

Create a bar chart to start with. The select the 3rd data series and use
the right click in order to change the chart type to line.
Now select the 4th data series and use F4 to repeat the charttype
change. Repeat for the 5th series.

Obviously you could do the same sort of thing but start with a line
chart and change 1st and 2nd to bar charts. But depending on your data I
think it would be easier to identify the data series as bars rather than
lines.

Cheers
Andy
 
Back
Top