×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Graph Large Amounts of Data
2

Graph Large Amounts of Data

Graph Large Amounts of Data

(OP)
I am acquiring measurements every minute for 1000 hours and need to graph the results so that I can analyze the results.  I have started creating the graph in Excel, but there is a 32,000 data point limit.  I could create 2 charts, each having half of the data, but I would like something a little more "slick" that I could scroll through and zoom in on short periods of time.  Does anyone have any idea how to accomplish this?

Thanks in advance,
Brian

RE: Graph Large Amounts of Data

You only have 60,000 data points, so that's something that Excel can swallow.  You would then need to wrap some VBA around the data with a couple of slider controls to make that happen.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

RE: Graph Large Amounts of Data

Two things seem to jump out:

1.  If you need to plot all of the points, you probably don't need such fine resolution.  Make a copy and delete every second point with a macro (or someone might be able to suggest an easier way).

2.  If you need the resolution, you probably don't need to plot all the points.
 

RE: Graph Large Amounts of Data

Your data can span multiple Series on a single graph.

If your data is in A1:B60000, set SeriesA to cover cells A1:B32000, and SeriesB to cover A32001:B60000.

Edit the graph so that both series have the same color, dot type, etc, and for most purposes it's no different than if all the data was represented by a single series.

Some options like having Excel draw a best fit line won't work, but those same results can be simulated using other Excel functions.

RE: Graph Large Amounts of Data

bsj,

You can also set up an offset function tied to a slider bar.  Name the range that you want to graph and use the offset function in the name range dialogue.  I have used this for repetative date on equipment downtime.  It allows you the ability to scroll through smaller sections of the chart at a time.  I found a tutorial on it at

http://www.datapigtechnologies.com/ExcelMain.htm.  Found a lot of good excel stuff there that I was able to use every day.


 

Alan M. Etzkorn  machinegun elk
Manufacturing Engineer
Wabash National Corp.
www.wabashnational.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources