Bar and Line plots on the same chart

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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
 
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
 
Thank you Andy - it works :-)
Dave

Andy Pope said:
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
Click to expand...
 
Back
Top