Bar and Line plots on the same chart

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
 
A

Andy Pope

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
 
D

Dave

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top