Thank you Andy - it works :-)
Dave

"Andy Pope" wrote in message
...
Hi,

Yes, you need to plot the line as an xy-scatter in order to get the line
to go vertically. with Y values being used to align the points with the
bars.

Cheers
Andy

On 12/05/2010 16:05, Dave wrote:
Is there a way to have some data plotted as bars and other data as lines
on
the same chart?

Appreciate any suggestiuions.

Dave
WinXP SP3 Office (Excel)2003



--

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