Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a Workbook where I enter my Blood Pressure on a daily
basis and plot it on an X-Y chart over time. The chart automatically expands the X-axis as new data is entered. I recently changed medication and placed a draw object (vertical line with a caption) at the appropriate date. The problem is that as the X-axis expands and the time between tick marks contracts, the draw object stays at the same position and I have to move it to the correct date tick mark. As the marks become more compressed, it has become difficult to move the object to the exact date. Is there any way to lock a draw object to a specific data point so it remains at the same relative position? Thanks for any help. Mike Hogan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pasting worksheet with embedded charts | Charts and Charting in Excel | |||
Charts won't update | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
Can't create dynamic charts | Charts and Charting in Excel |