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

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

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