Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
ArtZ
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stock High-Low-Close Chart Tim Charts and Charting in Excel 7 August 24th 07 01:02 PM


All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"