I have a worksheet of our daily cash position forecast for about 6 months
out. From this data there is a line chart. How can I set it up to
automatically identify and label the the minimum value over the next 90 days?

In the worksheet I use the min function to identify the amount.

Thank you,

Aaron

Hi,

Apparently I also included a label minimum example :)
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy

Aaron wrote:
I have a worksheet of our daily cash position forecast for about 6 months
out. From this data there is a line chart. How can I set it up to
automatically identify and label the the minimum value over the next 90 days?

In the worksheet I use the min function to identify the amount.

Thank you,

Aaron

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

I have one of those as well:

http://peltiertech.com/Excel/Charts/FormatMinMax.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Andy Pope wrote:

Hi,

Apparently I also included a label minimum example :)
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy

Aaron wrote:

I have a worksheet of our daily cash position forecast for about 6
months out. From this data there is a line chart. How can I set it up
to automatically identify and label the the minimum value over the
next 90 days?

In the worksheet I use the min function to identify the amount.

Thank you,

Aaron