[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 169
  • Last Modified:

Excel 2010 Scatter graph - distinguishing multi same-value points

I'm wishing to create a scatter graph in Excel 2010 which has many points which have the same value.  Each point has significance and so I need to clearly distinguish and label them on the graph, so that when one looks at a point on the graph they can readily see which  points it relates to.
(I thought there used to be a setting for labels in which you could select option to not have labels overlap)

I have attached an attempt, poor and unsuccessful as it may be, to do this.
Example-Scatter-Graph.xlsx
0
gh_user
Asked:
gh_user
  • 2
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

there is no easy, out-of-the-box tick box that you can select for this. In a previous question we had a lively discussion about the possibilities. See here.  

cheers, teylyn
0
 
gh_userAuthor Commented:
Hi Teylyn.
Yes, I can see there is no easy solution from that discussion.
I did a google search and came up with the following discussion (www superuser.com/questions/194041/excel-scatter-chart-with-labels)
in which add-ins such as chart labeller were suggested.
Not sure if this would work, and how successful it would be if I need to share excel file with others (would they need to install addin)

Geoff
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

the chart labeller tool is very useful for sourcing label text from worksheet cells instead of the standard options (category, value), but it will not help in avoiding label overlap.

This is a difficult challenge and there is no easy fix.

cheers, teylyn
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now