ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I enter a missing data point? (https://www.excelbanter.com/excel-discussion-misc-queries/51401-how-do-i-enter-missing-data-point.html)

Paul

How do I enter a missing data point?
 
When I enter a lot of data in a sheet, and make a graph of it. Missing points
become "holes" in the graph. How do I tell Excel that tha point is missing,
so the graph is countinous?

bj

How do I enter a missing data point?
 
try
<tools<options<graph and select interpolate for current graph

"Paul" wrote:

When I enter a lot of data in a sheet, and make a graph of it. Missing points
become "holes" in the graph. How do I tell Excel that tha point is missing,
so the graph is countinous?



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

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