I'm working on creating an XY-Scatter plot using index to find the correct X and Y values. The Y values plot perfectly fine, yet my X values seem to be using [1,2,3,4,5..] instead of the actual values.
I read the post about the bug in SP1 but this is SP2. I'm not all that great with excel and seem to have exhausted my options on figuring this out. Any help would be GREATLY appreciated.. I really wouldn't be surprised if it were something small I'm overlooking.
The sheet in question is Sheet 3 on the attached spreadsheet.
Bookmarks