I run a query every day against a database to produce a text file I import into Excel (2003) as an aid in producing some reports. The graphs present viusally four of the columns of data against a date range, which is a fifth column of data. The last three days of query-running are shown. I just have a couple of formatting questions.
1) For reasons best known, I suppose, to Excel itself, the worksheet for April 24 chose not not provide my 'Target' data label for 13-May-14. On the April 25 refresh, 13-May is provided, but 12-May and 14-May are not. On the April 28 version, 12-May and 14-May are back, 13-May is missing again, and also 15-May. Any ideas why Excel is deciding not to present some of the data labels for this trendline, and why the data points he doesn't present vary from day to day?
2) On the April 24 graph, the 'Revised Target' data label for the 16-Jun-14 data point displays '99', although the value in the underlying data for that point is clearly '396'. On the April 25 graph, the mistaken data label has moved to the 17-Jun data label, and on the April 28 graph it has moved to the 18-Jun data point. Why is Excel deciding to display '99' instead of the given value for one of the data points (and why does it move around)?
3) As long as we're on the April 28 graph (I manually placed the data labels along the trendlines on the other two graphs), the data labels for 'Target' don't appear very close to the points they represent, and particularly, the label for the 12-May-14 data point has hopped way up above the 'Revised target' trendline. And the 'Revised Target' data label for 13-May-14 is slightly to the right of the data label for 14-May-14. Is there any way to get the data labels to appear right along the trendlines they represent?
For those who need to understand the data in order to evaluate better what's going on:
I provide reports to the development and testing teams in my shop to monitor progress of testing the changes for the next release of our main application. I run 17 queries against our development and testing database, and import the results into 11 worksheets which form the basis for the reports. This is one of the worksheets. The testers create test scenarios and load them into the system, and then PASS or FAIL them as they are tested. The column graph shows the number of scenarios passed as of each day, and the number not passed. Once the reporting is actually in the scheduled testing time period, the columns will stay. The area graph - Target - shows how many scenarios need to be passed each day at a consistent rate to get the testing done by the scheduled end of testing. For these graphs, since testing hasn't officially started yet, Target shows the number of scenarios loaded for each day before the testing 'starts'. The line graph - Revised Target - is intended to show how many scenarios need to be passed each day, given how many had been passed as of the day before reporting.
Bookmarks