Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stock Bar Charts
how do I add the "open" to a stock bar chart in Excel?
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stock Bar Charts
In the OHLC type candlestick charts, Open and Close define the top and
bottom of the up-down bars. Excel doesn't offer the commonly used left-tick for open, just the right tick for close. I have one technique to simulate this on my web site: http://peltiertech.com/Excel/Charts/...tTickOpen.html and I have since developed a much easier technique, which I have yet to write up. Sometime soon, perhaps. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Akistner" wrote in message ... how do I add the "open" to a stock bar chart in Excel? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stock Bar Charts
Thank you - exactly what I was looking for!!
"Jon Peltier" wrote: In the OHLC type candlestick charts, Open and Close define the top and bottom of the up-down bars. Excel doesn't offer the commonly used left-tick for open, just the right tick for close. I have one technique to simulate this on my web site: http://peltiertech.com/Excel/Charts/...tTickOpen.html and I have since developed a much easier technique, which I have yet to write up. Sometime soon, perhaps. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Akistner" wrote in message ... how do I add the "open" to a stock bar chart in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Stock List | Excel Discussion (Misc queries) | |||
Pasting worksheet with embedded charts | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
Comples Stock Charts | Charts and Charting in Excel | |||
stock charts | Charts and Charting in Excel |