Dear all,
i have a database on excel and i would want to creat a chart that would work for this database
how ever , the data base is constantly changing and i would like a chart that would only count all the cells wich is in this database and not more and not less.
since the last cell in the row is empty , I would think there is might be a way to set the chart "Untill blank" cell in the row.
Is there any way to do so ? maybe a VBA way to do so ?
Thanks
Hi,
You can do this using a dynamic chart and named ranges. If you perform a forum search on these keywords all should become clear!
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
Thanks!
I think i got it now![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks