Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
level line
Hi All,
I have a line graph with minutes on y axis but scaling may vary from small values to large ones. I want to draw a level line at 15 minutes with AddLine method. I can do that manually, but how can I calculate the position of 15 minutes (in points as required by the AddLine method) on y axis if its place varies with scaling of y axis? (or is there any other way?) Thanks, Stefi |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
level line
What's more, also the actual window size influences the place of 15 minutes
on the chart! Stefi €žStefi€ť ezt Ă*rta: Hi All, I have a line graph with minutes on y axis but scaling may vary from small values to large ones. I want to draw a level line at 15 minutes with AddLine method. I can do that manually, but how can I calculate the position of 15 minutes (in points as required by the AddLine method) on y axis if its place varies with scaling of y axis? (or is there any other way?) Thanks, Stefi |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
level line
Hi,
Rather than adding a line from the drawing toolbar consider using another data series to draw the line http://www.andypope.info/charts/averageline.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Stefi" wrote in message ... Hi All, I have a line graph with minutes on y axis but scaling may vary from small values to large ones. I want to draw a level line at 15 minutes with AddLine method. I can do that manually, but how can I calculate the position of 15 minutes (in points as required by the AddLine method) on y axis if its place varies with scaling of y axis? (or is there any other way?) Thanks, Stefi |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
level line
€žStefi€ť ezt Ă*rta: What's more, also the actual window size influences the place of 15 minutes on the chart! Stefi €žStefi€ť ezt Ă*rta: Hi All, I have a line graph with minutes on y axis but scaling may vary from small values to large ones. I want to draw a level line at 15 minutes with AddLine method. I can do that manually, but how can I calculate the position of 15 minutes (in points as required by the AddLine method) on y axis if its place varies with scaling of y axis? (or is there any other way?) Thanks, Stefi |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
level line
Thanks Andy, in the meantime I've found also
http://peltiertech.com/Excel/Charts/AddLine.html Now I have several ways to choose from! Stefi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a dotted line to a solid line in a line graph | Charts and Charting in Excel | |||
Zoom level | Excel Discussion (Misc queries) | |||
Plotting a fixed level line on a chart | Charts and Charting in Excel | |||
How do I do a two level Vlookup? | Excel Worksheet Functions | |||
need to add colored horizontal line on chart to show cutoff level | Charts and Charting in Excel |