1. Charts use absolute referencing.

2. When you sort a range, links to cells within the sorted range stay
pointing at the same cell with respect to the cell containing the link. If
the cell is outside the sorted region, it stays pointed to the same absolute
cell, whether the link was relative or absolute. So if the chart points to
row 2 of a range before sorting, it points to row 2 of the range after
sorting.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
ps.com...
Hi, This is probably easier than I make it out to be but here goes.

I'm making a list of references I've been using for a research paper in
excel and because the list is quite large (50 sources) I wanted to
visually depict how useful each reference is. So I created a bubble
chart with "relevance" on the x-axis and "quality of the source" on the
y-axis which references a 1-4 scale for relevance and quality. That
works fine, but when I want to sort references, let's say by date, the
references for the chart data are absolute, which means if a Row is
sorted up or down, the chart in that row will still reference the
previous cell data it was in. Of course I tried turning the absolute
references into relative, but excel changes them back to absolute
everytime!! Is there a way around this? I hope i didn't just confuse
everyone. Any help is appreciated.