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.
Problem developing graph
I'm not sure if I need to use something other than a pivot table to get what I want from this data. Data: ID,Software,Date Purchased,Type,Age 1,Access,5/9/2018,Database, 1 2,Excel,5/7/2018,Spreadsheet, 2 3,Access,5/3/2018,Database, 6 4,Minecraft,4/14/2018,Game, 25 5,SQL Server,4/28/2018,Database, 11 6,Excel,5/6/2018,Spreadsheet,3 7,SQL Server,5/7/2018,Database, 2 8,Excel,5/1/2018,Spreadsheet,8 9,SQL Server,5/9/2018,Database, 1 10,Minecraft,5/1/2018,Game,8 I can display the average and max values of my raw data. I can also show the "count" of the different "types" of software. What I *want* to show, each with a separate line, is: * Average Age * Max Age * Number of Database items * Number of Spreadsheet items (Note: items 3 and 4 are combined in the grey line above... plus there is another category ("game") that is included in the gray line that I do not want to show up.) Please help? Thanks.
