Weekly Data Imports to track status changes and new line items

Closed
Chris - May 5, 2017 at 07:12 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 9, 2017 at 10:57 AM
Hello,

What method would I use to import data into excel that contains line item numbers that increase each week? Additionally each week the number of line items grow and there would be changes in the stages of line items imported from week one. I would like to create charts that show a total of line items at various stages in a process. Week two import would have the same line items as week one, but they may be in a different stage of the process this week. Plus there would be new line items as well. Week three would have totals of week two, plus new items, and updates to new process stages that week one and week two items are in. And so on and so on. Could each week import be on separate tabs that data on each tab could be compared to the previous week's tab to display on graphs? Thanks for ideas!
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
May 9, 2017 at 10:57 AM
Hi Chris,

What does your data look like? And what data would you like to show in your graphs?

Some sample data would be nice.

Sample data of week 1 and how the graph looks like, then of week 2 and how this changes the graph.

Let us know.

Best regards,
Trowa
0