| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
can I change data markers to numbers in a scatter chart?
|
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
can I change data markers to numbers in a scatter chart?
Hi,
Set the data markers to none and use data labels instead. Set the Position of the data label to center. If the number you want to display is not the x or y value then you can link the data label to a cell which contains the value you require. Try either of these free addin to make the linking of cells and data labels easier. Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com Cheers Andy treez wrote: -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| labeling data points on a scatter chart | Charts and Charting in Excel | |||
| I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
| Data labels on scatter chart | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| change font color of first cell in data table attached to chart | Charts and Charting in Excel | |||
Linear Mode
