I have a list of data that goes beyond the worksheet limitation of 65536 rows. How do I include data from 2 separate tabs onto the same series for a graph? For example if I have 70k rows of data, how do I include the 4500 rows that are in worksheet #2 in the same series as the 65k+ rows in worksheet #1?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
graph question
- Thread starter emansun
- Start date
Oaktree
MrExcel MVP
- Joined
- Jun 20, 2002
- Messages
- 8,120
- Office Version
- 365
Are you building an S curve (e.g. cumulative sales on the y-axis, number of accounts on the x-axis)? Or, why do you want 70,000 data points on a graph?
If it's for an S curve, I'd recommend *against* putting (or trying to put) all 70,000 on the chart. It will be really slow to redraw and eat up a bunch of memory you don't need to. Instead, I'd put the top 100 (or whatever number you decide) and then every 1,000th (or whatever number you decide). That way, the graph will hold its shape without the aforementioned issues.
If it's for an S curve, I'd recommend *against* putting (or trying to put) all 70,000 on the chart. It will be really slow to redraw and eat up a bunch of memory you don't need to. Instead, I'd put the top 100 (or whatever number you decide) and then every 1,000th (or whatever number you decide). That way, the graph will hold its shape without the aforementioned issues.
Upvote
0
Similar threads
- Question
