Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
novice
 
Posts: n/a
Default how do i plot data consisting of 1000 lines in excel sheet

hi all,
i need to plot a data which has about 1000 lines in excel xy scatter chart.
please help me
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default how do i plot data consisting of 1000 lines in excel sheet

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

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


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.charting
James Silverton
 
Posts: n/a
Default how do i plot data consisting of 1000 lines in excel sheet

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
Multiple worksheet queries liam Excel Worksheet Functions 3 February 16th 05 06:52 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Getting specific data from a word document into an excel sheet smintey Excel Worksheet Functions 3 December 7th 04 05:17 PM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"