Bar and Line chart type in Excel 2000

[dunner44]

I have 4 series of data in a bar chart. If I change the chart type to a bar/line chart, it changes the last two series to line format, and the top two series to bar format. I want the top 3 series to be a bar, and the last series to be a line. Is there an easy way to make a line formatted series into a bar formatted series?

TIA

 

[SkipVought]

Hi,

Select each individual series and change the Chart Type for each accordingly.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}