Re: Stock chart with indicator on same chart

I've dealt with something similar.

construct the chart without the indicator

copy the range of the indicator data and paste it into the chart.
select the range for the new indicator
format the series, select a secondary Y axis
adjust the axis to the same scale as the other axis.


Scrunchy wrote:

>I am trying to get a chart with open, high, low, close
>and an indicator.
>
>What I would like is if the open, high, low close used
>one side of the chart to measure and the indicator used
>the other as they are in different ranges of numbers.
>
>Not getting it so far and the help is less than helpful.
>Any help or direction to resources would be appreciated.
>
>Scrunchy
>
>

--
Gary Klass
gmklass@ilstu.edu
Editor, PSRT-L
4600 Politics and Government
Illinois State University
Normal, Illinois 61790
http://LILT.ILSTU.EDU/gmklass
(309) 438-7852
(fax) 438-7638
The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow

I've posted some instructions on my web site.

http://www.geocities.com/jonpeltier...kChartPlus.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Gary Klass wrote:
> I've dealt with something similar.
>
> construct the chart without the indicator
>
> copy the range of the indicator data and paste it into the chart.
> select the range for the new indicator
> format the series, select a secondary Y axis
> adjust the axis to the same scale as the other axis.
>
>
> Scrunchy wrote:
>
>> I am trying to get a chart with open, high, low, close and an indicator.
>>
>> What I would like is if the open, high, low close used one side of the
>> chart to measure and the indicator used the other as they are in
>> different ranges of numbers.
>>
>> Not getting it so far and the help is less than helpful.
>> Any help or direction to resources would be appreciated.
>>
>> Scrunchy
>>
>>
>