+ Reply to Thread
Results 1 to 3 of 3

Thread: Chart until blank?

  1. #1
    Registered User
    Join Date
    07-27-2010
    Location
    Hadera Israel
    MS-Off Ver
    Excel 2007
    Posts
    11

    Chart until blank?

    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

  2. #2
    Forum Guru sweep's Avatar
    Join Date
    04-03-2007
    Location
    Location: Location:
    MS-Off Ver
    3.0
    Posts
    2,472

    Re: Chart until blank?

    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.

  3. #3
    Registered User
    Join Date
    07-27-2010
    Location
    Hadera Israel
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Chart until blank?

    Thanks!
    I think i got it now

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0