+ Reply to Thread
Results 1 to 2 of 2

Creating a Graph with an unknown amount of data

  1. 02-19-2009, 02:36 PM #1
    pink
    pink is offline
    Registered User
    Join Date
    02-09-2007
    Posts
    39

    Creating a Graph with an unknown amount of data

    Hello!

    I'm trying to create a bar graph using Macros, but the data range varies.

    For example

    The spreadsheet may have
    Please Login or Register  to view this content.

    or it may have 
    Please Login or Register  to view this content.

    The data will be in the same columns. I just don't know how many rows of data there will be to set static values for the data range.

    Thank you for any help
    Reply With QuoteRegister To Reply
  2. 02-19-2009, 04:47 PM #2
    Kenneth Hobson
    Kenneth Hobson is offline
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Creating a Graph with an unknown amount of data

    Have you tried using a dynamic named range? Dynamic Named Ranges for Series

    Here is another method that you can adapt.
    Please Login or Register  to view this content.
    Last edited by Kenneth Hobson; 02-19-2009 at 05:00 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1