Add label on a chart

[hurriance]

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 som
information. How can I draw the line

 

[Bernard Liengme]

Start by displaying the drawing toolbar (View | Toolbars, check Drawing)
You need to make sure the line is part of the chart, not just a line on top
of the chart (which will not move when the charts is moved) - we call this
grouping
To do this click the chart BEFORE you click the line tool on the Drawing
toolbar
best wishes

 

[Andy Pope]

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