Chart question - how to display 3 series as a bar chart and oneseries as a line

[Dave K]

I have four data series (one of which is a total for the other three
series).

I want to display the total as a line, and the other three series as a
bars (all in the same chart, and with the numbers on the Y axis and
the categories on the X axis).

Data is below.

Is there a way to accomplish that? Thanks for any suggestions.

Fri Mon Tues Wed Thurs
red 1061 1059 1065 1065 1066
green 3682 3679 3709 3722 3732
blue 283 283 277 283 292
Total 5026 5021 5051 5070 5090

 

[Dave K]

Ok i think i figured it out. At least one way to do it was to simply
use the chart toolbar, select the series that i wanted to change, and
then change the chart type for that series.