Bar and Line plots on the same chart
 

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

Bar and Line plots on the same chart
 

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

Bar and Line plots on the same chart
 

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