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...
 

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

Similar Threads

Line and Bar on same chart 2
Odd chart type needed 2
Line Chart & Bar Chart Combined 2
multiple series bar and line chart 2
Excel 2007: Lines not displaying on Scatter Plots 1
Surpressing plot of blank cells 3
How to change series plotting order without changing legend order? 6
Seemingly random plot area drift? 2

Back
Top