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.