ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Usenet Groups > Excel Charting

Notices

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 08-28-2008, 12:22 PM
andrewc andrewc is offline
Registered User
 
Join Date: 08 Feb 2005
Posts: 88
andrewc is on a distinguished road
Adding a line to a chart

Hi,

I have created a scatterplot chart. Now I would like to add a straight line to the chart with the formula y=x (ie. a line that goes through the origin at 45 degrees)

Can someone please suggest how to do this.

Thanks!
Reply With Quote
  #2  
Old 08-28-2008, 12:37 PM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Moderator
 
Join Date: 10 May 2004
Location: Essex, UK
Posts: 2,305
Andy Pope will become famous soon enough Andy Pope will become famous soon enough
You need to add another series which has 2 pairs of co-ordinates.
This would define the bottom Left and top right position, or vice versa, of the line.

If you want the line to touch the edge of the plot area you will need to fix the scales Min and Max values.
__________________
Cheers
Andy
Reply With Quote
  #3  
Old 08-29-2008, 07:22 AM
andrewc andrewc is offline
Registered User
 
Join Date: 08 Feb 2005
Posts: 88
andrewc is on a distinguished road
Cheers Andy
Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting one column to text file Brelin Excel Programming 11 08-21-2008 01:29 AM
Stoppage line on line chart schnett Excel Charting 1 08-07-2007 03:36 PM
Adding line to a stacked bar chart ritz Excel Charting 1 04-12-2007 04:57 AM
Adding a specific constant value line to chart harryg Excel - New Users 1 02-05-2007 07:58 PM
Going insane! kik Excel - New Users 10 01-31-2007 08:21 AM


All times are GMT -4. The time now is 05:33 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0