Chart with extra line

[Guest]

I have fifteen numbers that I have added, averaged, found the median and
standard deviations for. I have charted these fifteen numbers as columns.
How do I display a line through the chart that can curve through the columns,
that is, one chart over the other?

 

[Guest]

add a data set with the numbers you want to plot to the chart.
select the new data set
change the axis to secondary and then
<chart><chart type> Select the line chart and hit enter
play with the formating and scale on the right side of the chart to make the
lines doo and look like you want.

 

[Jon Peltier]

If the line represents calculations based on the columns, the OP may not
need to use the secondary axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

Again I agree, but I couldn't tell what the relative values were so wanted
to be most "Generic".