Chart with extra line

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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/
_______
 
Again I agree, but I couldn't tell what the relative values were so wanted
to be most "Generic".
 
Back
Top