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.


--
Kepf
------------------------------------------------------------------------
Kepf's Profile: http://www.excelforum.com/member.php...o&userid=30611
View this thread: http://www.excelforum.com/showthread...hreadid=507440

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