Combination stock and scatter chart

  • Thread starter Thread starter ArtZ
  • Start date Start date
A

ArtZ

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
 
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/
_______
 
Back
Top