|
|||||||||||||||||||||
|
#1
|
|||
|
|||
|
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! |
|
#2
|
||||
|
||||
|
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. |
|
#3
|
|||
|
|||
|
Cheers Andy
|
![]() |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
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 |