Thread: Chart with extra line

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.

"Jvermont@aol.com" wrote:

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

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/
_______


bj wrote:

> 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.
>
> "Jvermont@aol.com" wrote:
>
>
>>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?

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

"Jon Peltier" wrote:

> 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/
> _______
>
>
> bj wrote:
>
> > 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.
> >
> > "Jvermont@aol.com" wrote:
> >
> >
> >>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?
>

Maybe I replied to this one first, and got on a roll.

Let's change one line of your explanation so the reader knows s/he has a
choice:

>>>change the axis to secondary *if necessary* and then

Now we can all be happy!

- Jon

bj wrote:

> Again I agree, but I couldn't tell what the relative values were so wanted
> to be most "Generic".
>
> "Jon Peltier" wrote:
>
>
>>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/
>>_______
>>
>>
>>bj wrote:
>>
>>
>>>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.
>>>
>>>"Jvermont@aol.com" wrote:
>>>
>>>
>>>
>>>>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?
>>