Dougmeister
New Member
- Joined
- Sep 23, 2010
- Messages
- 42
I have a simple graph based on a pivot table.
Raw Data
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.
Raw Data
Code:
ID,Software,Date Purchased,Type,Age1,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.
Last edited: