General Chat Thread, Excel Problem in General; I'm trying to create a dynamic chart in Excel, i.e. it updates when more data rows are added. Done the ...
2nd November 2007, 11:08 PM #1
I'm trying to create a dynamic chart in Excel, i.e. it updates when more data rows are added. Done the first bit of getting that to work, but now its trying to apply it to my own spreadsheet. How do I count the number of cells in a row that have data in them so I know the range to be plotted. Have tried Count and Counta but they count the cell if it has a formulae in it as its therefore not empty. I need to find out what cells don't have a value in it, wether or not it has a formulae in it.
By sqdge in forum Office Software
Last Post: 10th February 2013, 07:18 AM
Last Post: 14th July 2011, 05:55 PM
By wesleyw in forum How do you do....it?
Last Post: 29th August 2009, 12:23 PM
By DSapseid in forum Windows
Last Post: 7th November 2007, 05:56 PM
By Norphy in forum Windows
Last Post: 17th January 2006, 11:19 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)