Combination stock and scatter chart

[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

[Jon Peltier]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>