Re: Stock chart with indicator on same chart
by Gary Klass » Tue, 01 Jul 2003 07:03:23 GMT
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.
--
Gary Klass
XXXX@XXXXX.COM
Editor, PSRT-L
4600 Politics and Government
Illinois State University
Normal, Illinois 61790
http://www.**--****.com/
(309) 438-7852
(fax) 438-7638
The Chart of the Week: http://www.**--****.com/
Re: Stock chart with indicator on same chart
by Jon Peltier » Thu, 03 Jul 2003 12:00:02 GMT
I've posted some instructions on my web site.
http://www.**--****.com/
- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.**--****.com/
_______
Similar Threads:
1.Technical Indicator below Stock Chart
Hello,
I am trying to create a stock chart including a technical indicator or
spoken more generally, I have two time series and I would like to graph
one line below the other line. (I do not want to have two y-axis!)
Basically I would like to have two charts below each other like you can
see it on any stock chart including an indicator on various websites.
Does anyone have an idea how I can handle that?
Cheers
Andreas Vester
2.Horizontally Banded Chart Background. - on Stock charts
I have 3 series of data, Hi/Lo/Avg that I am plotting using a Stock
type chart with 3 data points.
I want to use a Horizontally Banded Background to indicate the desired
range.
I have read and tested Jon P's excellent article on Horizontailly
Banded Chart Background, and tested it successfull on a line chart.
However when I test it on the 3 var Stock chart it does not work.
Can anyone give me a suggestion for a way to do what I want with
either my stock type of chart or an alternative way to show what I
want to indicate.
Thanks from American Samoa
JDB
3.Cannot combine stock charts with other chart types in Excel 2007
4.Combination of stock chart and line chart
Dose anyone know how to plot a stock chart and a line chart together in
combination ? I tried but can't seem to do it, is it possible in Excel ?
One way is stock chart with open, high, low and close plus volume but I need
to plot 2 other lines.
Thanks,
Hiromichi
5.High/low stock chart with line chart
any help appreciated...is it possible to plot a
high/low/close stock chart with an additional series on a
second axis?
for example
stock high/low/close price - y axis 1
p/e ratio - y axis 2
6. Provide a "high/low" chart (stock chart) in horizontal mode
7. Scatter chart Indicator size
8. Charting with Difference indicator