Mouse hover on area graphs shows incorrect values

What is confusing the display is that the X-Axis on the chart is being treated as a date axis. This takes the lowest date and the highest date and sort of spreads them out evenly. However these do not necessarily match up with the data points.

If, you select the axis and force it to be a Text Axis, the dates are correct. However, the #N/As show up.

Fortunately, your date ranges are contiguous. It is possible to assign a named dynamic range that looks only at those cells that have dates in them. I start with some helper cells.

The first finds the row on which the first real date occurs. =MATCH(TRUE,ISNUMBER(Sheet2!$C:$C),0) - This is entered as an array formula.

The next cell gets this starting position relative to the start of the data. Since the data starts on row 3, subtract 3 from the absolute row found.

Next we need the number of dates there actually are: =COUNT(Sheet2!$C:$C) - count counts only numbers, and dates are numbers,

We now have all the pieces we need to construct the named range: Plot_X =OFFSET(Sheet2!$C$3,'Helper Calculations'!$B$2,0,'Helper Calculations'!$B$3,1)
This formula says:
- Start in Cell C3 on sheet 2
- Go down the number of rows shown in cell B2 on the helper sheet
- Go right zero columns
- Return a range of cells equal to the number in cell B3 on the helper sheet and 1 column wide.

The second range is: Plot_Y =OFFSET(Plot_X,0,1) which essentially says PLot_Y, shifted one column to the right and no rows down.

These are used to plot the chart. Make sure you set the chart to Text Axis.

For more details on the Offset Command and Dynamic Charting see:
http://www.utteraccess.com/wiki/Offs...Dynamic_Ranges
http://www.utteraccess.com/wiki/Dynamic_Charting