graph question

emansun

New Member
Joined
May 21, 2007
Messages
3
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?
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,128
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
  2. Mobile
  3. Web
I think you might want to upgrade to Office 2007 for that.
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,105
Office Version
  1. 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.
 

Forum statistics

Threads
1,181,647
Messages
5,931,209
Members
436,784
Latest member
amuljono

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top