LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 18th 12, 03:32 PM posted to microsoft.public.excel.charting
external usenet poster
First recorded activity by ExcelBanter: Oct 2012
Posts: 1
Default XY scatter plot with more than 32000 rows in Excel 2003


I am using Excel 2003 and need to plot on the same xy scatter chart 24 series (column) of data, each series containing about 300,000 rows of data (spread across 5 worksheets in the same workbook).

I am aware of the 32,000 rows limitation per series in Excel 2003 and the workaround of creating a new series for each chunk of 32,000 rows to append to the previous chunk. However, I would need to do that 24 times x 9 (~300,000/32,000) for that one chart, and I have six similar charts to do (6 x 24 = 144 columns in total), so I am looking for a more automated way of doing that. Unfortunately, my VBA skills are pretty much inexistent so I was wondering if there was a kind soul out there who could help me or at least get me started.

Many thanks in advance,


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
Scatter Chart - plot x&y coordinates - Excel 2003 suejay Charts and Charting in Excel 1 January 17th 07 05:43 AM
Excel Scatter Plot adamuk Charts and Charting in Excel 2 March 27th 06 01:48 PM
3D Scatter plot in Excel Havard Charts and Charting in Excel 1 June 8th 05 02:15 PM
Can I copy x-y scatter plot data direct from one plot to another? Chris Charts and Charting in Excel 2 June 3rd 05 01:20 PM
Excel scatter plot Sam Excel Programming 1 December 12th 03 04:15 PM

All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017