Reference Circle in Scatter Chart

[prabhu0505]

I have a chart like Image-1 I want to add a couple of reference circles to it and make it look like image 2.

Appreciate any help!

[swuehl]

Maybe just use an image as frame background (on Colors tab, AFAIR)?

[prabhu0505]

Reference circle radius should be dynamic.

[sebastianlettner]

Hi,

you could add two expressions to the chart (if it's a line chart) for a circle.

But you need a numeric X-Axis

1. Circle half top

    sqrt(pow(vRadius, 2) + 0.000000001 - pow(X-Axis, 2))

2. Circle half bottom

    -sqrt(pow(10, 2) + 0.000000001 - pow(X-Axis, 2))

Or, if you need an ellipse use this expressions

1. Ellipse half top

     Sqrt(Pow(vRadiusY, 2)*(1-Pow((X-Axis), 2)/Pow(vRadiusX,2)) + 0.000000001)

2. Ellipse half bottom

     -Sqrt(Pow(vRadiusY, 2)*(1-Pow((X-Axis), 2)/Pow(vRadiusX,2)) + 0.000000001)

(See attached .QVW)

Otherwise I think this is not possible.

Regards

Sebastian Lettner

[prabhu0505]

Your answer has opened few doors for me, trying with those. Thanks!