ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Data labels on chart (https://www.excelbanter.com/charts-charting-excel/196324-data-labels-chart.html)

Eric

Data labels on chart
 
I'd like to add data labels to some of the data points on a line chart.

I know how to do it manually, but I'd like to do it in a way that
permanently associates the data label with the data point in the underlying
data series.

For example, I might have a graph of stock prices, which would show jumps or
drops at certain points. I might want to label one point with "Yahoo rejects
Microsoft offer" and another with "Apple introduces iPhone".

I'm using Excel 2003.

Thanks.

Wigi

Data labels on chart
 
Put the labels in an extra column.

Then, check out Rob Bovey's nice Chart labeler:
http://www.appspro.com/Utilities/ChartLabeler.htm

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Eric" wrote:

I'd like to add data labels to some of the data points on a line chart.

I know how to do it manually, but I'd like to do it in a way that
permanently associates the data label with the data point in the underlying
data series.

For example, I might have a graph of stock prices, which would show jumps or
drops at certain points. I might want to label one point with "Yahoo rejects
Microsoft offer" and another with "Apple introduces iPhone".

I'm using Excel 2003.

Thanks.



All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com