I am using Excel 2016 for Mac and from reading other forums, my understanding is that I don't have access to VBA 
I receive a worksheet consisting of daily metrics that I would like to plot over time. To illustrate with an example, imagine that each row has a name of fruit (bananas; apple; orange). Column A's title is "fruit", and Column B is "daily sales". (simple 2 column report). My end goal is to be able to create a line graph for each fruit with a datapoint for each day.
Questions:
1) is it possible to create a graph "series" that spans multiple workbooks? If so, how?
In the absence of question #1, I have manually copied each day's report to a new "master" workbook and then created a "summary" worksheet that is populated by manually copying the "daily sales for each fruit" (column B in my example above) into the "summary" worksheet. I have then created an additional worksheet where I have created a separate graph for "bananas", "apples", "oranges", etc.
2) is there a way to automate the population of the "summary" worksheet? I explored using "data consolidation" but this appears to only aggregate data (average, min, max, etc) across a range, not consolidating individual entries onto one worksheet.
Thanks for your suggestions
I receive a worksheet consisting of daily metrics that I would like to plot over time. To illustrate with an example, imagine that each row has a name of fruit (bananas; apple; orange). Column A's title is "fruit", and Column B is "daily sales". (simple 2 column report). My end goal is to be able to create a line graph for each fruit with a datapoint for each day.
Questions:
1) is it possible to create a graph "series" that spans multiple workbooks? If so, how?
In the absence of question #1, I have manually copied each day's report to a new "master" workbook and then created a "summary" worksheet that is populated by manually copying the "daily sales for each fruit" (column B in my example above) into the "summary" worksheet. I have then created an additional worksheet where I have created a separate graph for "bananas", "apples", "oranges", etc.
2) is there a way to automate the population of the "summary" worksheet? I explored using "data consolidation" but this appears to only aggregate data (average, min, max, etc) across a range, not consolidating individual entries onto one worksheet.
Thanks for your suggestions
