Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 22nd 07, 07:11 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 5
Default How do you add straight lines to a candlestick chart?

I created a candlestick chart for foreign exchange rates, but I want to add
several horizontal lines indicating the high for the range (using formula
MAX), the low for the range (using formula MIN) and an additional trade rate
line (manual input) without having to manually draw the three lines each
time.

So for example, I would create a candlestick chart for Currency A within the
past two weeks. Let's say the 2-week range is between 115 and 130, and the
trade rate is 120. I want to automatically add horizontal lines at 130 and
115 (indicates the range) and a line at 120. This is using the same y-axis
rates, just a different charting type. This seems pretty basic but I'm
absolutely frustrated! I appreciate anyone who can help! BTW, I'm using
Excel 2003.

Thanks!

  #2   Report Post  
Old May 23rd 07, 10:02 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default How do you add straight lines to a candlestick chart?

http://peltiertech.com/Excel/Charts/AddLine.html

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


"scshop" wrote in message
...
I created a candlestick chart for foreign exchange rates, but I want to add
several horizontal lines indicating the high for the range (using formula
MAX), the low for the range (using formula MIN) and an additional trade
rate
line (manual input) without having to manually draw the three lines each
time.

So for example, I would create a candlestick chart for Currency A within
the
past two weeks. Let's say the 2-week range is between 115 and 130, and
the
trade rate is 120. I want to automatically add horizontal lines at 130
and
115 (indicates the range) and a line at 120. This is using the same
y-axis
rates, just a different charting type. This seems pretty basic but I'm
absolutely frustrated! I appreciate anyone who can help! BTW, I'm using
Excel 2003.

Thanks!





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
Excel and Candlestick Chart? Mike Charts and Charting in Excel 1 August 7th 06 08:37 PM
Excel and Candlestick Graphs!? Mike Excel Discussion (Misc queries) 2 August 7th 06 08:00 PM
straight line graph, really straight line.. Jason Excel Discussion (Misc queries) 2 July 20th 06 10:08 PM
Vertical Lines on the Lines on 2 Axes Chart [email protected] Charts and Charting in Excel 3 March 3rd 06 04:14 AM
How do we generate Candlestick chart using Microsoft Excel? silver23 Charts and Charting in Excel 0 April 30th 05 11:32 PM


All times are GMT +1. The time now is 08:27 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017