Weekly Data Imports to track status changes and new line items

Closed
Chris - May 5, 2017 at 07:12 PM
TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 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!

1 reply

TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
512
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