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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks