Weekly Data Imports to track status changes and new line items

[Closed]
Report
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
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!

1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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