Can a stock chart be combined with an line chart?

I would like to overlay a line chart on a stock chart. Is there a way to do
this?

Stock Chart with Added Series
http://peltiertech.com/Excel/Charts/StockChartPlus.html

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


"karenjoy511" <karenjoy511@discussions.microsoft.com> wrote in message
news:6B04E49C-BDE9-4570-90C0-99178E2EA4EE@microsoft.com...
>I would like to overlay a line chart on a stock chart. Is there a way to
>do
> this?

Thank you for the link. I got stuck on the step where you select the added
series and convert it to a scatter plot. When I tried to do that, I got a
message that said "some chart types cannot be combined with other chart
types. select a different chart type." I tried to select each different kind
of scatter plot type but none would work. I am using Excel 2007, if that
makes a difference.
can someone help me?

"Jon Peltier" wrote:

> Stock Chart with Added Series
> http://peltiertech.com/Excel/Charts/StockChartPlus.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "karenjoy511" <karenjoy511@discussions.microsoft.com> wrote in message
> news:6B04E49C-BDE9-4570-90C0-99178E2EA4EE@microsoft.com...
> >I would like to overlay a line chart on a stock chart. Is there a way to
> >do
> > this?
>
>
>

Excel 2007 doesn't realize you can combine a stock chart with another
chart type (the designers probably never used Excel for real work).

You'll have to start from scratch. Make a chart with four line chart
series (open, high. low, close in that order) and one XY series, with
all series on the primary axis. On the middle chart tools tab, add
high-low lines and up-down bars. This adds these features to the line
chart series, effectively making it a stock type chart. Then format each
line chart series to remove any lines and markers.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



aaf26lon wrote:
> Thank you for the link. I got stuck on the step where you select the added
> series and convert it to a scatter plot. When I tried to do that, I got a
> message that said "some chart types cannot be combined with other chart
> types. select a different chart type." I tried to select each different kind
> of scatter plot type but none would work. I am using Excel 2007, if that
> makes a difference.
> can someone help me?
>
> "Jon Peltier" wrote:
>
>> Stock Chart with Added Series
>> http://peltiertech.com/Excel/Charts/StockChartPlus.html
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> http://PeltierTech.com
>> _______
>>
>>
>> "karenjoy511" <karenjoy511@discussions.microsoft.com> wrote in message
>> news:6B04E49C-BDE9-4570-90C0-99178E2EA4EE@microsoft.com...
>>> I would like to overlay a line chart on a stock chart. Is there a way to
>>> do
>>> this?
>>
>>