Too much thinking going on

[JoeBanks001]

I have an excel workbook with 400 rows of data 40 columns wide. I need to be able to view the data in a paredo chart. This data is updated monthly so the chart will need to be updated once the data has been cut and paste. I have tried it 2 ways-building 400 tabs with VLOOKUPS to gather the data as well as fewer tabs with multiple graphs per page. Both give me a fault after about 150 graphs that "no more fonts may be added". At this point I cannot add more graphs, tabs or anything. Also at this point the formulas quit working. Computer and server memory are good. I am now efforting to build a new workbook using only 1 graph that is populated by a macro button beside each item. (Click the button and it jumps to the graph and populates it) This should drop the memory requirements exponentially. How many macros can I use in a workbook on 1 sheet? I am trying for 400ish. Is there a way to generate these macros quickly rather than 1 at a time?

 

[RoryA]

The too many fonts error is usually caused by the font on the chart being set to auto-scale. If you turn that off, the problem should go away. Having said that, do you actually need 400 charts? It would be easier to have one whose datasource you can change using a dropdown, or a group of charts (if you need easy comparisons) that you can change similarly.