This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
| Week | Site 1 closed order | site 2 closed order | Site 1 new order | site 2 new order |
|---|---|---|---|---|
| 3/8/2024 | 1000 | 2000 | 2000 | 3000 |
| 3/15/2024 | 1000 | 2000 | 2000 | 3000 |
| 3/22/2024 | 1000 | 2000 | 2000 | 3000 |
| 3/29/2024 | 1000 | 2000 | 2000 | 3000 |
| 4/5/2024 | 1000 | 2000 | 2000 | 3000 |
I want a weekly data where Site 1 closed order and site 2 closed order are stacked and site 1 new order and site 2 new order are stacked in a different column. Kindly help
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi,
I have solved it using Power Query and Pivot Tables. You may download the file from here.
Hope this helps.
You are welcome. Please mark my previous reply as Answer.
Thank you so much
Question, how will the graph will look? I am looking for something like this. Trying for long to find a way to create this graph in excel but no luck so far,
Load the data into Power Query, right-click the Week column and choose "Unpivot other columns".
Result:
Andreas.