login.php profile.php?mode=register faq.php memberlist.php search.php index.php

Index du Forum » Communauté So'Graph » Tutoriaux/Aides graphiques » need formula so graph does not just drop when no data?
Poster un nouveau sujet  Répondre au sujet Sujet précédent :: Sujet suivant 
need formula so graph does not just drop when no data?
MessagePosté le: Sam 30 Déc - 08:29 (2017) Répondre en citant
Langue pendue
Langue pendue

Hors ligne
Inscrit le: 09 Oct 2017
Messages: 205


What I need is to display a graph of data as I add data to the cell range.  If there is no data in the subsequent cells then I do not want to see a graph of these empty cells at the bottom of the chart.   

What is happening is that my graph is growing until I get to an empty cell -- then the graph just drops tothe bottom of the chart and I have a line all the way to the right end of the chart along the x axis.  

I am guessing that since there is a formula in these empty cells that this is why the graph is displaying the line.   If I use a cell range without formulas -- the graph just stops -- as desired when there are empty cells. 

 Is it possible to achieve this same effect with formulas in the empty cells?  how to do this?

Please help.


I didn't find the right solution from the Internet.


  Online Promotional Advertising Examples

MessagePosté le: Sam 30 Déc - 08:29 (2017)

PublicitéSupprimer les publicités ?
need formula so graph does not just drop when no data?
Index du Forum » Tutoriaux/Aides graphiques
Toutes les heures sont au format GMT + 2 Heures  
Page 1 sur 1  

 Poster un nouveau sujet  Répondre au sujet  

Index | forum gratuit | Forum gratuit d’entraide | Annuaire des forums gratuits | Signaler une violation | Conditions générales d'utilisation
Powered by phpBB © 2001-2004 phpBB Group
Designed for Trushkin.net | Themes Database
Traduction par : phpBB-fr.com