ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Combination of stock chart and line chart (https://www.excelbanter.com/charts-charting-excel/207-combination-stock-chart-line-chart.html)

hwatari

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


Jon Peltier

Hiromichi -

I have written an explanation on this web page:

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

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

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



Andrew Glennie

Combination of stock chart and line chart
 
Thanks heaps Jon. It helped me too.

"Jon Peltier" wrote:

Hiromichi -

I have written an explanation on this web page:

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

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

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





All times are GMT +1. The time now is 08:43 PM.

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