ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   chart 4 stock in OHLC type candlestick (https://www.excelbanter.com/charts-charting-excel/160237-chart-4-stock-ohlc-type-candlestick.html)

bobaldo

chart 4 stock in OHLC type candlestick
 
Hello Everyone,

I have a problem. I would like to chart 4 stock in OHLC type candlestick in
the same chart.
I was wondering if it was possible to do.
Do you thing it's possible ? and if it's possible how to obtain this chart ?

Many Thanks by advance.

Best Regards.

Jon Peltier

chart 4 stock in OHLC type candlestick
 
The best you can do is one candlestick on the primary axes and one on the
secondary axes, then line up the axis scales.

Of course you could plot as many closing price series as you want on the
same chart (as long as you want less than 256).

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


"bobaldo" wrote in message
...
Hello Everyone,

I have a problem. I would like to chart 4 stock in OHLC type candlestick
in
the same chart.
I was wondering if it was possible to do.
Do you thing it's possible ? and if it's possible how to obtain this chart
?

Many Thanks by advance.

Best Regards.




bobaldo

chart 4 stock in OHLC type candlestick
 
Thanks for your answer Jon


"Jon Peltier" wrote:

The best you can do is one candlestick on the primary axes and one on the
secondary axes, then line up the axis scales.

Of course you could plot as many closing price series as you want on the
same chart (as long as you want less than 256).

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


"bobaldo" wrote in message
...
Hello Everyone,

I have a problem. I would like to chart 4 stock in OHLC type candlestick
in
the same chart.
I was wondering if it was possible to do.
Do you thing it's possible ? and if it's possible how to obtain this chart
?

Many Thanks by advance.

Best Regards.






All times are GMT +1. The time now is 08:54 AM.

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