Combination stock and scatter chart
 

Hi,

Could anyone suggest a way to add stock data bars (HLC) to a scatter
chart? It is easy to go the other way and add the scatter chart data to
a stock chart, however, there is not much flexibility in the x axis
format time scale. I tried to add the stock data a scatter chart and
the result was simply three additional lines on the chart representing
the H, L, and C. I could not figure out a way to get stock bars.

Suggestions?

Thanks,

Art


--
ArtZ
------------------------------------------------------------------------
ArtZ's Profile: http://www.excelforum.com/member.php...o&userid=30226
View this thread: http://www.excelforum.com/showthread...hreadid=499019

Combination stock and scatter chart
 

Art -

The Close point is normally indicated using the short dash marker (6th in
the list). You can use +/- error bars for the lines from Close to High and
Low. Define values in the worksheet that show High-Close and Close-Low, and
use these ranges as input for custom error bars. Also see this explanation
of error bars:

http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

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


"ArtZ" wrote in message
...

Hi,

Could anyone suggest a way to add stock data bars (HLC) to a scatter
chart? It is easy to go the other way and add the scatter chart data to
a stock chart, however, there is not much flexibility in the x axis
format time scale. I tried to add the stock data a scatter chart and
the result was simply three additional lines on the chart representing
the H, L, and C. I could not figure out a way to get stock bars.

Suggestions?

Thanks,

Art


--
ArtZ
------------------------------------------------------------------------
ArtZ's Profile:
http://www.excelforum.com/member.php...o&userid=30226
View this thread: http://www.excelforum.com/showthread...hreadid=499019