i have this info on sheet 2
Date of meeting Clients in funding over 90 days
1/1/2005 150 130
2/1/2005 145 110
3/1/2005 130 90
4/1/2005 155 50
5/1/2005 85 20
6/1/2005 100 10

i am trying to make a line chart that shows the meeting date at bottom and a
line for clients in funding and a line for over 90 days

when i try to do this it always gives me a total of one for each of those on
the table and posts as such on the chart...

--
gtsch

Try this:

Ensure all your figures are indeed figures and are not text which look
like figures.
Place cursor in your table
Press the F11 key adds a new chartsheet
Rightmouse clight in the chart and select chart type - line


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=533997