any way to bypass Excel Limit of 255 rows?

G

griff

hello all

I have a data range that is over 600 rows deep, and would like to build one
line chart which is based on selections using autofilters. I don't want
everything charted (as I'm filtering), but I can't create the initial chart
as there's a max limit of 255 rows.

Any ideas anyone?

cheers

griff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Pivot charts, any way to display filters on the chart? 1
Data Range Question 1
Excel Charts and Shapes or Text Boxes that disappear 0
Dual Axis Horizontal Bar Chart in Excel-can I avoid overlapping ba 8
excel chart maximum series should more than 255 series 4
esudden extreme slowdown of charting 2
XY Scatter Plot - Change Labels From Numeric To Text Programmatica 8
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1

Top