I have a scatter chart that is working the way i want, but when i want to add an average line to the chart, it runs, but my data changes. any ideas how i can do this?
on my data tab on chart properties, i have an AVERAGE in the Values section. On the Y: axis expression i have =AVG(Fields!proteintest.Value). when i add this i only get a couple points of data on my chart instead of the 40 like it should have. it also changes my x axias from 1-50 to 0-2
on my data tab on chart properties, i have an AVERAGE in the Values section. On the Y: axis expression i have =AVG(Fields!proteintest.Value). when i add this i only get a couple points of data on my chart instead of the 40 like it should have. it also changes my x axias from 1-50 to 0-2
