In Microsoft Excel, I have a data set of about 5000 rows and columns. I need to create multiple charts in different sheets for every 100 rows. What's the best way to do that? Thank you.
It is better to write VBA code for this purpose. VBA code can make this job smooth and you can create what did you want. Also there are several Chart plugins like SmartCharts for Excel, which can be helpful.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 1  Reply