Hi,
Consider using extra data series to highlight special points in your data.
Jon Peltier has an explanation here.
http://peltiertech.com/Excel/Charts/PointAtPoints.html
I also have an example here,
http://www.andypope.info/ngs/ng47.htm
Cheers
Andy
hurriance wrote:
I have a line graph to show the no. of customer in each day.
In the graph, some peak is shown(i.e. the day with many customer).
At each peak, I want to add a label and a line/arrow to show some
information. How can I draw the line?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info