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