Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line Chart | Charts and Charting in Excel | |||
Moving data labels around with VBA (and adding a line between two | Charts and Charting in Excel | |||
Label an average line in a dynamic chart | Charts and Charting in Excel | |||
Line chart in Excel - trendline incomplete | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |