Weekly Data Imports to track status changes and new line items [Closed]

Report
-
Posts
2731
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 22, 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
2731
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 22, 2021
459
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!