Hi, I have a data table "logsheet" that's populated from a userform.
I have several pieces of data that I'd like to display using some graphs.
I'd like to be able to change the graphs to update the display by having some sort of year/month picker and the graph will pick up the month or year from the data table.
Am I better off building a table to collate the data and then turning this into graphs or should I take the data direct from the "logsheet" table into a graph?
I have multiple sets of data I'd like to display but they do not have to be on the same graph, the plan is to have 3/4 graphs on one page. I have attached a sample workbook with the type of information I'm after in blue.
I'm learning so any advice on the bast way to achieve my result would be appreciated. I'm not expecting anyone to do it for me as I'd like to give it a try myself but don't know how best to achieve my result.
Bookmarks