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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |