VBA: creating a chart from data

GMHLee

New Member
Joined
Aug 26, 2020
Messages
1
Office Version
  1. 2010
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,118,750
Messages
5,574,016
Members
412,563
Latest member
marianmalone2019
Top