ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to generate on a chart or spreadsheet a date line marker (https://www.excelbanter.com/excel-programming/420206-how-generate-chart-spreadsheet-date-line-marker.html)

u473

How to generate on a chart or spreadsheet a date line marker
 
How do I generate on a chart or worksheet, a date line marker which
would be a red arrow pointer object.
pointing to the 8th period out of 12 for example.
At this point, the Period # could be given in cell A1. [In the future
I would work directly with dates].
All I remember is that MOVE and TWIPS are involved.
To get some clues, I started the Macro Recorder as usual [From Excel
2007] to insert an arrow pointer,
make it red, position it, etc... but it did not record any of my
actions.
Your help will be appreciated,
J.P.

u473

How to generate on a chart or spreadsheet a date line marker
 
Thanks a lot. This is putting me in the right direction.
JP.


All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com