Plotting lines and data points on scatter chart

I'm trying to produce a chart that has both actual data values from a database and matching "line of best fit" plots on the one chart. I have 4 data series, 2 of the actual data values and 2 that represent the values for the "line of best fit". What I want to do is:

Plot the actual values just as data points (joining them with lines in meaningless) and

Plot the "line of best fit" values as a line.

When I edit the data series on the scatter chart, I can see the "Plot data as line" option but it is "greyed" out.

Have I missed something really simple here or is this not possible. I'm using RS2005

Many thanks

Simon

Hi Simon,

I have the same problem now.

Have you found a solution for your problem?

Thanks

Gerd

Plotting lines and data points on scatter chart

I'm trying to produce a chart that has both actual data values from a database and matching "line of best fit" plots on the one chart. I have 4 data series, 2 of the actual data values and 2 that represent the values for the "line of best fit". What I want to do is:

Plot the actual values just as data points (joining them with lines in meaningless) and Plot the "line of best fit" values as a line.

When I edit the data series on the scatter chart, I can see the "Plot data as line" option but it is "greyed" out.

Have I missed something really simple here or is this not possible. I'm using RS2005

Many thanks

Simon

Hi Simon,

I have the same problem now.

Have you found a solution for your problem?

Thanks

Gerd

Plot Area

If I understand it right, the Plot Area includes the plotting of <Legend> as
well as actual <Chart diagram>.
Can I specify the size and location of the actual <Chart diagram> apart from
the <Plot area> '
I run into an overlapping of two Legends, when superimposing two charts..!
If I could, specify the size and location of the actual <Chart> and let RS
handle the Legend between the actual <chart diagram> and the <Plot Area>, I
can then specify different locations for Legends on these superimposed charts
and thereby resolve the overlapping (of Legend) issue!!!
Thanks.
Thanks.No, but you can specify the legend location in the Legend tab in Chart
Properties dialog.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:91924BE2-96AE-4056-99AD-A36DD315D700@.microsoft.com...
> If I understand it right, the Plot Area includes the plotting of <Legend>
as
> well as actual <Chart diagram>.
> Can I specify the size and location of the actual <Chart diagram> apart
from
> the <Plot area> '
> I run into an overlapping of two Legends, when superimposing two charts..!
> If I could, specify the size and location of the actual <Chart> and let RS
> handle the Legend between the actual <chart diagram> and the <Plot Area>,
I
> can then specify different locations for Legends on these superimposed
charts
> and thereby resolve the overlapping (of Legend) issue!!!
> Thanks.
> Thanks.