Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vertical line isn't vertical!
Hello -
I searched yesterday for help on inserting a 'dynamic' (ie moving) vertical line into a graph and found the below instructions: ********************************** 1. On your worksheet, enter the date you want to mark, in two cells, one above the other (e.g. G3:G4). To have the current date appear in these cells, use the Today function: =TODAY() 2. In the cell to the right of the top date, enter a zero 3. In the cell to the right of the lower date, enter a formula to calculate the maximum number in the data range, e.g.: =MAX(A1:G30) 4. Select the 4 cells, and copy or drag them onto the chart (add them as a new series). 5. Select the new series 6. Choose ChartChart Type 7. Choose the XY(Scatter) chart type, and the Scatter with Lines subtype, click OK 8. Format the line as desired, e.g. thick line with no markers. *********************************** This worked great....except that the resulting line isn't vertical, it's more of a 85deg angle! The line appears to go from the center of the data (on x-axis) to the right of the data. What am I doing wrong? Thanks! ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a vertical line to a column chart | Excel Discussion (Misc queries) | |||
Followup:Add vertical line at intersection of 2 curves (Ping AndyPope) | Charts and Charting in Excel | |||
Vertical scroll bar jumps scrolls line 1 to line 2705? | Excel Worksheet Functions | |||
Moveable Vertical Line | Charts and Charting in Excel | |||
Program line when charting variances? | Charts and Charting in Excel |