Stock chart with indicator on same chart

MS EXCEL

    Next

  • 1. equations
    how can I display the equation of a line on my graph?
  • 2. Time-Line Chart
    I'm trying to create a "time-line" chart on both sides of the X axis. For example, item '1' lasts (3) seconds long and is 'positive' (above X axis). Item '2' lasts (2) seconds and is 'negative' (below X axis). Item '3' lasts (5) seconds and is 'positive'. Every time I graph this the lengths of the items are graphed vertically instead of horizontally. Any suggestions? *** ***** _________________ ** Thanks, Zack
  • 3. How can you rotate the text within the text box so that the text .
    Help. Need advice on how to move my text within a text box to align with the box's direction. For example, if I have an arrow pointing at an angle from left to right, how do I ensure that the text move with my box? Thanks in advance.
  • 4. division problems
    I am trying to keep track of softball stats, I trying to compute batting average. I have at bats in column b, hits in column c. I am trying to get the averages in column d, but I can not get the formula right, I keep getting error messages. The result is less than 1
  • 5. Secdonary X axis
    I am creating a XY Scatter plot with two different data sets. I want the two different data seta on two different x-axis. How can I do this?

Re: Stock chart with indicator on same chart

Postby 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

Postby 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



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 96 guest