davidmichael99
New Member
- Joined
- Nov 1, 2013
- Messages
- 5
I need some advice on this pivot table/chart I have created. It’s my first attempt at a pivot table/chart, and I need it to accomplish two things. First: Easily compare data from test 1 to test 2 depending on a specific date. Second: a density graph where the change in density may be seen over a selected time span.
Question:
1. To get the Y axis on the charts for test 1 and test 2 I had to set the "Summation Values" field to take an average. I don’t really need any mathematical analysis on the data just a display of the values to compare test results from test 1 and 2.
2. Is this a good use of a pivot table, or is there a better route I could take to get the information across?</SPAN>
3. Comments or critiques welcome and appreciated
4. Is there a way I can better explain this problem, or upload the excel file to the forum thread so people can get a better idea of what I’m trying to accomplish?
</SPAN>
***Using Excel 2010***
</SPAN>
Question:
1. To get the Y axis on the charts for test 1 and test 2 I had to set the "Summation Values" field to take an average. I don’t really need any mathematical analysis on the data just a display of the values to compare test results from test 1 and 2.
2. Is this a good use of a pivot table, or is there a better route I could take to get the information across?</SPAN>
3. Comments or critiques welcome and appreciated
4. Is there a way I can better explain this problem, or upload the excel file to the forum thread so people can get a better idea of what I’m trying to accomplish?
</SPAN>
***Using Excel 2010***
</SPAN>
