add-in that CAN create big charts of 100 x 100

[excelfrogs]

I don't mind paying for the add-on/add-in, I need to have a chart displayed of 100 rows and 1000 cells of data. Is that possible? Quick reply would be appreciated, thanks!!

 

[excelfrogs]

anyone please?? ^^^

 

[andiemac]

First I'll say that Excel 2007, with no special add-ins, will create a chart based on your range of 100 rows and 100 columns. But with that much data I would argue that it's not very useful. In fact as some point it becomes unintelligible. Wouldn't it make more sense to break the data down into usable sets; by product line or region?

 

[excelfrogs]

I have Excel 2010 but it won't let me do it, 100 rows yes but 100 columns that go with it no

 

[andiemac]

What chart type are you needing to use?

 

[andiemac]

If you are using Excel 2010 would sparklines work for you? I'm not in 2010 so not sure what the constraints are for that.

 

[excelfrogs]

works sorry