Hi
I want to loop through every 4 columns in an Excel file and create line charts in a pdf file.
There is no upload function for me to show my Excel file as sample.
Basically create 4 lines in a single chart for Column B-E, another 4 lines in a 2nd single chart for Column F-I.
Column A will be the date, or x-axis in the charts
The excel file could have many set of 4 columns, so the code must loop through all of them and create all the charts in a single pdf file (1 chart per page).
How do I do so?
THank you
I want to loop through every 4 columns in an Excel file and create line charts in a pdf file.
There is no upload function for me to show my Excel file as sample.
Basically create 4 lines in a single chart for Column B-E, another 4 lines in a 2nd single chart for Column F-I.
Column A will be the date, or x-axis in the charts
The excel file could have many set of 4 columns, so the code must loop through all of them and create all the charts in a single pdf file (1 chart per page).
How do I do so?
THank you