Excel graph outliers
Hello, is there anybody who can help me with creating a graph that is showing the outliers? I want to state the numbers manually and I don't know how to do it. Like I already have the minimum, median and maximum but I don't know how to tell this excel so that it is making the outliers for me.
How to get "Shopping basket" in my Excel 2016
Hi, I have the Data Analysis pack add-in and solver add-in in my Excel 2016. However, I could not find the tab where i can see the "Shopping Basket Analysis" as shown in the microsoft website (https://msdn.microsoft.com/en-us/library/dn282369(v=sql.120).aspx) see the attached screenshot please help
Bi-Directional tables in Excel using Power Query or ADX
Is there a way to make bi-directional tables in excel?? In one sheet there is a full table and in sheet two there is a filtered table. In the example below, the simple problem description is shown. Idea is that users could change the value in table 2, so it is pushed back to table 1. Also when changed in table 1, the value is pushed to table 2. It is easy to use power query but then it is a one-way street. Currently Using Excel 2013 & Power Query. Any help is appreciated. Added simple excel file as an attachment as a basis.
