Hi all,
I am looking to streamline graph creation which uses raw data from a source that will regularly change (The data types in each column remains the same but names and numbers may vary).
I would be grouping data by month and separating series by year (for yearly comparison), and filtering by differing criteria.
Previously when making the graphs I sorted it all into a pivot table, copy/paste, create graph, then manually alter by hand (titles, series names, labels, etc.)
I'd like to be able to create a graph in a new worksheet, like the one above, directly from the raw data, is this feasible?
For example, instead of having VBA group the data into a pivot table with assigned filters, paste that table in the worksheet, then make the chart from that table, can I make a chart, like the one described above, with VBA directly from the raw data?
Thanks.
I am looking to streamline graph creation which uses raw data from a source that will regularly change (The data types in each column remains the same but names and numbers may vary).
I would be grouping data by month and separating series by year (for yearly comparison), and filtering by differing criteria.
Previously when making the graphs I sorted it all into a pivot table, copy/paste, create graph, then manually alter by hand (titles, series names, labels, etc.)
I'd like to be able to create a graph in a new worksheet, like the one above, directly from the raw data, is this feasible?
For example, instead of having VBA group the data into a pivot table with assigned filters, paste that table in the worksheet, then make the chart from that table, can I make a chart, like the one described above, with VBA directly from the raw data?
Thanks.