PDA

View Full Version : Combining three different tables in a chart



EirikDaude
06-14-2019, 03:21 AM
I have a workbook containing three tables in three different sheets. Each table looks something like this, with date- and timestamps in the two first columns, and then some measurements in the others. The headings for the relevant columns will be the same in all three table.
24392

What I want to do is to make several charts which show the average per day for each column heading. I.e. for Cu, I want a chart containing a line graph for each table, where each graph shows the average per day for the given table.

I thought I could do this using a pivot chart, but I am having some trouble combining the data.

Is there some way to do this without first processing the data further?