How can you create names?
define names
create from selection
How can missing date be handeled in diagramms?
insert diagramm
select data
hidden and empty cells
How can numbers change to absolut numbers?
= ABS ()
How can you prevent a line chart drop to zero?
= IF (Zelle = 0; NA(); Zelle)
-> NA() -> produzierte Fehler -> #N/A
How to change in a “different” diagramm with a different font?
=REPT(CHAR(162);B6/100)
-> Wiederholung der Buchstaben
in der gewünschten Schriftart
How to show in a diagramm +/- values in a chart?
positiv
=IF(D23>0;REPT($D$21;ROUND(D23*100;0));"")
negativ
=IF(D23<0;REPT($D$21;-ROUND(D23*100;0));"")
Last changed2 years ago