Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chart only cells with data

    Upon updating a worksheet, the number of cells in a column could increase or decrease. How can I designate the data range for a chart so it will chart however many cells there currently are in that column?

    Thanks,
    Eric

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Check out MS MVP Jan Karel Pieterse's article on dynamic names: http://www.jkp-ads.com/Articles/ExcelNames07.asp. He has also posted an example file of using it with a chart

    Steve

  3. #3
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks much. That looks like it holds more promise than other websites I've found.

    Eric

Posting Permissions

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