How to add a fixed point to a dynamic chart
 

Hi - Currently an ADODB-driven line advances (extends) across my Excel
chart as the weeks go by, giving an organization's cumulative income.
I want to add a single goal point at the end of the year so the members
of the organization can visually judge progress toward goal. Kindly
advise on how I can choose the symbol for the single point and how I
can add it to the dynamic chart. Thanks!

How to add a fixed point to a dynamic chart
 

Embarassing! After I submitted the query I realized that a trend line
is a better visual measure of progress and I added it.