how do i plot data consisting of 1000 lines in excel sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi all,
i need to plot a data which has about 1000 lines in excel xy scatter chart.
please help me
 
Hi,

A chart can only have 255 series, is that what you mean by lines?
It can however have 32K data points.

What sort of help do you need exactly?

Cheers
Andy
 
Andy wrote on Tue, 29 Nov 2005 08:35:34 +0000:

AP> A chart can only have 255 series, is that what you mean by
AP> lines? It can however have 32K data points.

AP> What sort of help do you need exactly?

AP> Cheers
AP> Andy

AP> novice wrote:
??>> hi all,
??>> i need to plot a data which has about 1000 lines in excel
??>> xy scatter chart. please help me

I don't really know what the OP actually wants but I think some
thought as to the actual purpose of a graph is needed. What can
actually be served by plotting *all* of an immense number of
data points? I leave aside the fact that depicting more points
than the screen resolution is quite a trick! As I have mentioned
before, both entertainment and enlightenment can be gained by
reading Edward Tufte's books, especially "The Visual Display of
Quantitative Information" and "Envisioning Information".


James Silverton
Potomac, Maryland.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I disable automatic chart creation in Excel? 1
XY scatter plot with more than 32000 rows in Excel 2003 0
Mixing scatter plot with a category plot 2
Not all my data is showing up in my chart... 1
Plot lines on an XY chart with some data column cells unpopulated 2
trendline in scatter plot 3
Charting scientific data - Excel 2003 5
I want to find the lowest point on the plotted line in a graph. 4

Back
Top