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

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" wrote
in message ...

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