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.
Last edited by shephejm; 08-24-2009 at 09:47 PM.
The correct values are plotted if you change the chart source range to include only the cells which contain numbers. I've added two dynamic ranges XPlot & YPlot to do this. You can see the formula for these in Name Manager.
Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks