Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I get 7.3 million data pts on one line graph?
I'm creating simple x,y line graphs with data collected at 2-minute intervals
over the course of a year. Since excel will only graph 32,000 data points in a given series, I'm only able to show ~a month and half of data on any one graph. Is there any way I can show an entire year of data (7.3 million data points) on one graph using excel or another program? |
#2
|
|||
|
|||
Obviously simple multiplication is also a problem for me. I need to get about 242,000 points on one graph. NOT 7.3 million. "tobesus" wrote: I'm creating simple x,y line graphs with data collected at 2-minute intervals over the course of a year. Since excel will only graph 32,000 data points in a given series, I'm only able to show ~a month and half of data on any one graph. Is there any way I can show an entire year of data (7.3 million data points) on one graph using excel or another program? |
#3
|
|||
|
|||
Excel is probably not the best tool for displaying or analyzing this
much data. One alternative might be the open source statistics package R, which can be freely downloaded from http://www.r-project.org/ Jerry tobesus wrote: Obviously simple multiplication is also a problem for me. I need to get about 242,000 points on one graph. NOT 7.3 million. "tobesus" wrote: I'm creating simple x,y line graphs with data collected at 2-minute intervals over the course of a year. Since excel will only graph 32,000 data points in a given series, I'm only able to show ~a month and half of data on any one graph. Is there any way I can show an entire year of data (7.3 million data points) on one graph using excel or another program? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Gappy data in line charts? | Charts and Charting in Excel | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
How do I include cell data in subject line of email address/hyperl | Excel Worksheet Functions |