Forum Discussion
Charting Monthly Data from different tables
So every month I receive updated data in new tables. I am really struggling to layer those data points together so I can show trends on a month-to-month basis. Do I need to add a column to each month...
Since you get new table with updated data every, I assume you have same structure on each table. You need to add an month identifier column in each table. Then you can use "Append Queries" feature to append to new data table into a single table.
When putting the data into a chart (visaul), just use that month identifier column as Category on X-axis.
Regards,