XY Scatter and a big amount of points

  • Thread starter Thread starter Josep Miquel Cubel
  • Start date Start date
J

Josep Miquel Cubel

Hi,
In my system XY Scatter there are a big amount of points , when I decide ,
I put a new value (x,y), two questions: what or how do you do this and Can
I have a clean view of the result ? ( the points are very close ).
Thanks,

Josep
 
Josep Miquel Cubel said:
Hi,
In my system XY Scatter there are a big amount of points , when I decide ,
I put a new value (x,y), two questions: what or how do you do this and Can
I have a clean view of the result ? ( the points are very close ).
Thanks,
Click to expand...

Once the number of points exceeds the number of horizontal pixels, you
must lose displayed points. As for displaying new points, Tushan Mehta
(meant thankfully and respectfully (g), not sarcastically) has already
discussed this under the topic of Dynamic Charts. You can of course
add a new row of values and extend the plotted range by clicking on
the chart and pulling the blue indicated area to include your new
point.
 
I'm not sure I understand the question about putting a new value.
Given a x (or y) value, do you want the corresponding y (or x) value?
If so, one possibility is Interactive Chart (http://www.tushar-
mehta.com/excel/software/interactive_chart_display/index.html)

If you want to add the point to the existing chart or if you want to
restrict the number of points shown, adapt the ideas in
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top