ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Uncertainty (https://www.excelbanter.com/charts-charting-excel/159796-uncertainty.html)

Simvastatin

Uncertainty
 
Hi, I've made a best fit graph and now I want to add the uncertainties to the
data. However, every time I enter the data into the correct cell it changes
the graph. How do I enter numbers into a cell, but have excel omit using
those uncertainty values in the graph?
Thanks for you time

Jon Peltier

Uncertainty
 
Put these numbers into a different cell.

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


"Simvastatin" wrote in message
...
Hi, I've made a best fit graph and now I want to add the uncertainties to
the
data. However, every time I enter the data into the correct cell it
changes
the graph. How do I enter numbers into a cell, but have excel omit using
those uncertainty values in the graph?
Thanks for you time




ShaneDevenshire

Uncertainty
 
Hi,

Jon has answered one question, but on the chance that you mean the chart
readjusts the scale - double-click the Y-axis and on the Scale tab uncheck
the boxes beside Maximum and Minimum.
--
Cheers,
Shane Devenshire


"Simvastatin" wrote:

Hi, I've made a best fit graph and now I want to add the uncertainties to the
data. However, every time I enter the data into the correct cell it changes
the graph. How do I enter numbers into a cell, but have excel omit using
those uncertainty values in the graph?
Thanks for you time



All times are GMT +1. The time now is 07:11 PM.

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