In reply to Cindy Wang.

Hi Cindy,
Thanks for your quick reply. I had a different requirement wherein the reference line for X-Axis was fixed, however the reference line for Y-Axis needed to be dynamic (i.e. calculated Average needed). Hence the graph would look like a Quadrant chart. Using Custom graph builder, I was able to overlay Bubble Chart and Series plot. This led to further complications. The data set I had was huge, hence I used ranking to pick top 10% to be displayed on the bubble chart. But the average value(i.e. reference line on Y-axis), was being calculated for the whole data set and not on the ranked data set. I want the average to be calculated only on the "ranked" data set. Could you please let me know if this is achievable?

Cheers,
Kiran