Add label on a chart

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?

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"hurriance" <[email protected]> wrote
in message news:[email protected]...
>
> 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?
>
>
> --
> hurriance
> ------------------------------------------------------------------------
> hurriance's Profile:
> http://www.excelforum.com/member.php...o&userid=30882
> View this thread: http://www.excelforum.com/showthread...hreadid=557444
>

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