A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Add an Average Line in a Scattergram



 
 
Thread Tools Display Modes
  #1  
Old September 29th, 2005, 06:06 PM
colbyatwood
external usenet poster
 
Posts: n/a
Default Add an Average Line in a Scattergram

In a scattergram, is there a way to have Excel show a line equal to the
average value of the data? I've been including an "extra" point in the data
that is equal to the average value and then manually drawing a line through
that point after I copy the chart into Word, but I'm hoping there's a more
elegant way to do this. I'm using Excel; 2003. Thanks!
  #2  
Old September 29th, 2005, 06:13 PM
Mike Middleton
external usenet poster
 
Posts: n/a
Default

colbyatwood -

In a scattergram, is there a way to have Excel show a line equal to the
average value of the data? I've been including an "extra" point in the
data that is equal to the average value and then manually drawing a line
through that point after I copy the chart into Word, but I'm hoping
there's a more elegant way to do this. I'm using Excel; 2003. Thanks!


One way: Enter XY data for two points on the worksheet (the start and end
points for the line). Use Chart | Source Data | Series (or other method) to
add the new data series to the chart. Format the new series Pattern to show
Line (automatic or custom).

- Mike
www.mikemiddleton.com


 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Label an average line in a dynamic chart John Cordes Charts and Charting 3 June 17th, 2005 09:42 AM
Average cost loizos General Discussion 2 June 13th, 2005 05:53 PM
Outlook 2003: annoying line wrap when quoting Tony Gravagno General Discussion 10 July 18th, 2004 12:17 AM
How to cut a line. Amit Joshi New Users 2 June 11th, 2004 05:05 PM
Average Line in Bar Graph? Michael Charts and Charting 1 January 21st, 2004 09:24 PM


All times are GMT +1. The time now is 09:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.