Home |
Search |
Today's Posts |
#1
|
|||
|
|||
= Drawing more lines in a OHLCV chart =
I have a stock database (Date,Open,High,Low,Close and Volume) and usually I
draw a stock OHLC chart to see it (i prefer chandlestics). However my surprise was I tried to draw a line in the chart, for example a simple moving average. If I try to include a new data serie to the original OHLC chart, it become distortioned. Finally can i include 2 or 3 moving averages in a OHLC chart. How can I do it? |
#2
|
|||
|
|||
See 'Stock Charts with Added Series' he
http://peltiertech.com/Excel/Charts/StockChartPlus.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ hcova wrote: I have a stock database (Date,Open,High,Low,Close and Volume) and usually I draw a stock OHLC chart to see it (i prefer chandlestics). However my surprise was I tried to draw a line in the chart, for example a simple moving average. If I try to include a new data serie to the original OHLC chart, it become distortioned. Finally can i include 2 or 3 moving averages in a OHLC chart. How can I do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I shade the area between two lines on a chart? | Charts and Charting in Excel | |||
Problem drawing lines on charts | Charts and Charting in Excel | |||
Changing chart orientation | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |