ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Scatter plots in excel 2007 (https://www.excelbanter.com/charts-charting-excel/191314-scatter-plots-excel-2007-a.html)

Rohini Gupta

Scatter plots in excel 2007
 
Hi,

I'm trying to create a scatter plot chart in excel 2007 with a label
on each point. But I can't seem to do this without creating 50
different series. I have three columns (x-axis, y-axis, and labels).
Is there a anyway to plot points and then at a separate label?

Jon Peltier

Scatter plots in excel 2007
 
You can add labels, then customize each one individually. If that's an
imposing task, try one of these free utilities:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Rohini Gupta" wrote in message
...
Hi,

I'm trying to create a scatter plot chart in excel 2007 with a label
on each point. But I can't seem to do this without creating 50
different series. I have three columns (x-axis, y-axis, and labels).
Is there a anyway to plot points and then at a separate label?





All times are GMT +1. The time now is 07:31 AM.

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