Microsoft Office Forums X/Y scatter chart with straight best fit line?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-01-2013, 09:53 AM
fmaduri fmaduri is offline X/Y scatter chart with straight best fit line? Windows XP X/Y scatter chart with straight best fit line? Office 2003
Novice
X/Y scatter chart with straight best fit line?
 
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, 4 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
X/Y scatter chart with straight best fit line? 4 quadrant scatter chart johnsongorj Excel 1 05-31-2012 12:08 PM
scatter chart gsrikanth Excel 1 03-07-2012 05:29 AM
How to create XY Scatter chart with quadrants Jamal NUMAN Excel 0 11-21-2010 04:37 PM
X/Y scatter chart with straight best fit line? Creating Scatter XY chart in Excel 2007, modifying the Y axsis niss3 Excel 1 10-27-2010 07:41 PM


All times are GMT -7. The time now is 02:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft