Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Chris Russell
 
Posts: n/a
Default How do I mark data points in an Excel chart as significant?

I have Excel 2003 and want to mark specific data points on a line chart as
statistically significant with some kind of symbol (*). I cannot for the
life of me figure out how to do this, or maybe it is not possible. Thanks
for the help in advance.
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Chris -

You can split the data into two series, and use a different symbol for
significant points. This web page has instructions:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Chris Russell wrote:

I have Excel 2003 and want to mark specific data points on a line chart as
statistically significant with some kind of symbol (*). I cannot for the
life of me figure out how to do this, or maybe it is not possible. Thanks
for the help in advance.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking the data from one excel to another mrbalaje Excel Discussion (Misc queries) 2 June 13th 05 10:44 AM
Fan charts Dean Charts and Charting in Excel 7 May 30th 05 11:51 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
How can deleted data reappear in a refreshed pivot table in Excel excel_user123456 Excel Discussion (Misc queries) 3 February 23rd 05 08:34 PM
multiple or changing colours in a data table on an excel chart fo. Kerri Buxton Charts and Charting in Excel 2 December 23rd 04 07:39 PM


All times are GMT +1. The time now is 08:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"