ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I mark data points in an Excel chart as significant? (https://www.excelbanter.com/charts-charting-excel/33104-how-do-i-mark-data-points-excel-chart-significant.html)

Chris Russell

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.

Jon Peltier

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.



All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com