ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Creating multiple charts from large data file (https://www.excelbanter.com/charts-charting-excel/221190-creating-multiple-charts-large-data-file.html)

smtt09

Creating multiple charts from large data file
 
I have a large data file (2000+ rows) from which I need to create several
similar charts. Each line chart has five series from columns that correspond
to dates which are in another column. I can make the individual charts
without a hitch; I am just looking for a way to minimize the time commitment
to make individual charts for each chunk of data.

The data is in columns with an empty row between each chunk. If it matters,
the not all of the chunks have the same number of rows of data. Can anyone
point me in the right direction.


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com