Adding comment (tool tip) in chart (to various elements of the chart, data points, etc.)
To be able to add comments to a specific data labels in a chart (can be bar chart, line chart)
Thanks for the feedback. This is an interesting idea that we’ll consider for a future release. Please continue to vote on this feature idea.
Alistair Higgins commented
Being able to comment against a chart, and to reference a colleague using the @name.domain format would be excellent. We use this to discuss Word documents across our team already and find the workflow it generates to be a great boost to productivity. All team members can see the discussion, which then does not have to be held "offline" in emails
Just came here to post this same suggestion.
Look at the site listed below (hope the URL survives this posting) for use case, demonstration of what a competitor is doing, and links to the lengths other people have gone to, to make this available in Excel. There are at least 3 Excel MVPs who have developed something similar over the years, but some of us can't install 3rd party add-ins, or the authors of the older solutions may not have the time to provide ongoing support.
This would make scatter charts 10x more useful.
Yes, this would be great. If scatter chart data series for example could take =series(<name>,<xValues>,<yValues>,<seriesNum>,<pointComment>,<pointSize>)
I do think that point size should be included in plot types other than bubble charts for extra functionality
One option on the tooltip could be "Select data". If a series is selected, then the "Select data" button would cause the chart to lose focus, and the cells on the worksheet that contain that series would be selected.
But if only one point were selected, then the "Select data" button would cause the chart to lose focus, and only the cells on the worksheet that define that point would be selected.
This would make it way easier to investigate outliers.
I agree. I will often look at a chart with hundreds of points, and I will see one outlier, and I want to know more about that point. It would be nice to see more than just the x,y values. At a minimum, I would want to know the row and column on the worksheet where the x and y are stored. This will help me investigate what makes it an outlier.
winston snyder commented
When hover on data point on XY Scatter Plot, display additional data about the data point beyond the name of the Series and the values of the xy coordinates. Sample here from Robert Mundigl: http://bit.ly/29V77UE