LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
wittmaennle
 
Posts: n/a
Default Adding a horizontal line to a stock chart

Hi!

I've got a stock chart displaying the average value and a high-low-line
for each value displaying the min/max value. Furthermore I have the
number of values the from which the min/max/avg values are derieved
plotted on the secondary axis.

Now I want to add a horizontal line for the primary axis at a given
value.
My solutions so far aren't really satisfactory.
Solution 1: drawing a line
Drawback: when the scaling changes, the line has to be
moved.

Solution 2: adding a new series with 2 fixed values and making a
trendline out of it
Drawback: the high-low-values are messed up

Are there any other possibilities? I think the solution given for line
and column charts by Jon Peltier isn't applicable - or do I miss
something?

Thanks in advance for any suggestions,
Rene

 
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
Line Chart Aurora Charts and Charting in Excel 1 March 8th 06 09:27 PM
Moving data labels around with VBA (and adding a line between two Caro-Kann Defence Charts and Charting in Excel 4 November 30th 05 08:51 AM
Label an average line in a dynamic chart John Cordes Charts and Charting in Excel 3 June 17th 05 09:42 AM
Line chart in Excel - trendline incomplete [email protected] Charts and Charting in Excel 7 May 13th 05 01:21 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 09:00 AM.

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

About Us

"It's about Microsoft Excel"