X Y charts labels are too cluttered . Need to make them more presentab

[krishna555]

I am using Excel 2007. I am creating X Y scatter plot chart ( "Chart1").
The plot uses the data "User_Experience" on the X scale and "Correlation_value" on the Y scale. I am able to plot the data correctly
Currently, there are too many values in the X Y scatter plot chart and the labels seem to be too cluttered and they are not legible and look a bit clumsy.

Is there a way in Excel chart creation or any VBA code by which I dont make the chart values too clumsy. I would like to just display the points on the scatter chart . Now, I would like all the label texts outside the plot area and link them to the data points with some arrows.

Is it possible that way?, If that is possible my chart plot area is not too cluttered and I would just have data points. All the label text is outside and linked through arrows or some other means.


Could some one please suggest

 

[SkipVought]

Hi,

It all depends on your data and what you are trying to show. Often, the actual data values are not the salient issue in a scatter chart, but rather the trend line and associated Min, max, slope, std deviation, inflection points etc.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[genomon]

There are several ways to cull your data down to a meaningful yet manageable size. Do a web search on data decimation; it's too complex to get into here, but I think it could be a possible solution.

Cogito eggo sum – I think, therefore I am a waffle.