LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How can I create a line chart with 800,000 data points

I have A LOT data in the following format:
column a, date and time, column b a number value.

I have 850,000 pieces of data for a 12 month time span. This data is in
multiple column combinations, something in the neighborhood of 20 columns by
40,000 or so rows each.

I want to display this data in a line chart. Excel seems to " choke" on the
data when I go to create the chart and select the data range if it is more
than 32,000 lines or data points. How can I chart this data? Thank you.
 
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
Line chart with Bubble data points [email protected] Excel Discussion (Misc queries) 1 December 13th 07 10:39 AM
Not plotting data points in a line chart NameDuJour Charts and Charting in Excel 1 November 1st 07 09:29 AM
how to put connecting line between data points on scatter chart? Marc Charts and Charting in Excel 2 November 24th 06 05:51 PM
Joining data points on a line chart JCW173 Charts and Charting in Excel 2 January 26th 06 12:38 PM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM


All times are GMT +1. The time now is 03:12 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"