Chart: 2 lines and a bar

[Kepf]

I have searched here and in the help file with no luck.

I see it is easy to have a graph with 2 bars and a line because it is one of the standards already set up.

But I need 2 lines and a bar and I cant figure out how to do it.

I'm sure it is something easy, but maybe this is a brain cramp or something.

[Andy Pope]

Hi,

Create line chart based on all three sets of data. Select the line
series that you want charted as a column and right click. From the popup
menu choose Chart Type. Select the required Column chart.

Cheers
Andy

Kepf wrote:
> I have searched here and in the help file with no luck.
>
> I see it is easy to have a graph with 2 bars and a line because it is
> one of the standards already set up.
>
> But I need 2 lines and a bar and I cant figure out how to do it.
>
> I'm sure it is something easy, but maybe this is a brain cramp or
> something.
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info