How much of your question is Excel specific (how do I create a chart in Excel?) and how much is the more generic "how to display this kind of data in a chart?" (independent of the application used to generate the chart?
If you are unfamiliar with creating charts in Excel, I would probably suggest you start with something like:
https://support.office.com/en-us/art...8-9c00cd03ff0c
https://support.office.com/en-us/art...2-fb094596f118
http://www.excel-easy.com/data-analysis/charts.html
These should get you familiar with the chart editing and formatting controls, and get you started creating charts.
If this is a more generic question, then I would probably start by asking myself exactly what I want to see with this analysis.
Are you looking to see the trend from 1st inspection to 3rd inspection? As explained in the links above, data layout can be important in creating charts. I might add some helper columns to copy the results of these into contiguous cells. Something like:
<row number> -- AF -- AG -- AH
1 -- 1st -- 2nd -- 3rd
2 -- =H2 -- =K2 -- =N2
3 -- copy and paste AF2:AH2 down to bottom of table.
Use these three columns in a line chart (you may need to execute a "switch row/column" command or go into the Select Source Data dialog to make sure it is using row 1 as the horizontal category axis data). You will likely want to only add a handful of rows to the chart, since 4000 lines on the chart will probably be way too much information on one chart.
Or maybe try a column chart, with column A or B as the horizontal axis data, with column H, K, and N as the Y series data. Again, 4000 data sets will be a lot to put on a single chart, but it will allow you to see something of the trend across properties and inspections.
From there, just try some different things to see what you like and don't like.
LinkBack URL
About LinkBacks
Trend Analysis
Register To Reply
Originally Posted by shg
Bookmarks