ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Technical Indicator below Stock Chart (https://www.excelbanter.com/charts-charting-excel/37015-technical-indicator-below-stock-chart.html)

[email protected]

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


Jon Peltier

Andreas -

If you want two stock charts (HLC), you need to put the second onto
secondary axes, or fake the hi-lo lines with error bars.

If it's just adding a regular line to the stock chart, try the procedure
he

http://peltiertech.com/Excel/Charts/StockChartPlus.html

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


wrote:
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


[email protected]

Jon,

Unfortunately, that's not what I need. I'll send you an email with an
image that shows what I am looking for.
Thanks so far.

Andreas


monstar

Hi Andreas, Jon,

did you find a solution to this matter?

Thanks.


All times are GMT +1. The time now is 04:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com