Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Jerry -
I didn't see your post earlier - so this may be far too late to help you... But if not - I also noticed that the lines are slightly off - and after having worked with it, I noticed that the vertical line marches along the x-axis as time goes by during the day. If my lines move day to day, then depending on the time of day, the line will move between the tick marks. Early AM has it closer to the tick mark on the left, and later in the afternoon/evening has the vertical line closer to the right tick mark. Please let me know if you still have a problem, and I'll see what I can do... -- Regards, John "Jerry" wrote: Hi! I was looking for the exact macro (I run it in a loop to highlight several event dates). However, when I apply the code, it is always slightly off: 1. Vertical bar but starts slightly above the plot area 2. It is also slightly off in terms of dates (about two days) This seems weird as everything in the code is automatic (.Top, etc.) I checked the axis and they are 100% standard, y cutting x at zero, etc. Am I missing something obvious? Thank you in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I draw a tangent line on a graph ? | Excel Discussion (Misc queries) | |||
Draw a horizontal bar and line graph | Excel Discussion (Misc queries) | |||
draw vertical line to mark today in diagram | Excel Discussion (Misc queries) | |||
How do i draw a regression line on a scatter graph | Charts and Charting in Excel | |||
Can I draw a tangent to a line in graph in Excel? | Charts and Charting in Excel |