Ray -

I suggest using the XY (Scatter) chart type for each of your data series.

You'll have better control over the X axis alignment (compared to the Line
chart type), and you can format some of the XY series to have line
connectors and some without.

- Mike
http://www.MikeMiddleton.com


"Ray Pendergast" wrote in message
...
Is it possible to create a chart that combines scatter and line elements?
I am comparing actual salaries with market standards. I can chart these
separately. I've got a line chart showing the 25th, Median and 75th
quartile
salaries for the industry at 1, 2, 3, etc. years of experience. I can
also
create a nice scatter graph that plots time on the X- and salary on the
Y-axis. The trouble comes when I want to combine the two.
The source data for the line chart has three columns of data (salaries
under
each category), plus a fourth for data series labels (# of years, whole
numbers). While the source data for the scatter is just two columns: time
(fractions of years) and salary.
Is there a common solution for this objective? If so, what topics in
Excel
help should I read up on?