View Single Post
 
Old 10-01-2013, 09:53 AM
fmaduri fmaduri is offline Windows XP Office 2003
Novice
 
Join Date: Oct 2013
Posts: 1
fmaduri is on a distinguished road
Default X/Y scatter chart with straight best fit line?

Hello,

I have tried everything I can think of to create an X/Y chart that shows a straight best fit line with no marker for each data series. If you look at the attached, the X axis is a logarithmic scale. Y axis is normal scale, is predicted compensation based on a linear regression (base salary and total compensation).

If you click on either data series (base or TCC), there doesn't seem to be a way to have a straight best fit line with no markers. I can add a trend line to either series, but that shows as a curved line, plus it gets added to the legend.

Any ideas? fmaduri@optonline.net

Thank you.
Attached Files
File Type: ppt Sample PIAA Chart Test.ppt (41.5 KB, 10 views)
Reply With Quote