Willow Talk

Re: Flags / Arrows in a chart

Posted By:

Email:

Date:

Time:

Comments:

You can use Excel’s conditional formatting to apply a specific format to the cell in a table containing the data series which will automatically identify when the last is equal to the high or the low or some other condition.

You can manually draw an arrow, which can be color coded, on a chart to identify certain points. However, if you want the process to occur automatically when the data is updated, you will need to write a macro.