ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   missing numbers for a line graph (https://www.excelbanter.com/charts-charting-excel/214869-missing-numbers-line-graph.html)

Heike

missing numbers for a line graph
 
Hi there,
I am just trying to create a line graph. I remember that I always used #NV
when there was no number or just blank. How can I do that in the english
version from Excel.

Jon Peltier

missing numbers for a line graph
 
In English that error is #N/A or =NA().

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Heike" wrote in message
...
Hi there,
I am just trying to create a line graph. I remember that I always used #NV
when there was no number or just blank. How can I do that in the english
version from Excel.





All times are GMT +1. The time now is 06:23 AM.

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