Results 1 to 3 of 3

chart based on dynamic range which resizes as per data in range-formula / vba

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    chart based on dynamic range which resizes as per data in range-formula / vba

    Hi all,
    Basic one.
    I am trying to make a chart based on dynamic name range.
    Currently it works fine, but it does not resize as per data in the range.
    e.g.
    In column 1 I have Names and in 2 numbers
    (A2:A26) named range 'Table'

    If I have 5 names and numbers then the graph must show 5 plots only
    and must resize as per data.
    I have visited various sites but cant get my head around.
    Please give me some hint or help so that I can understand it
    Many thanks
    Kind regards
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED]Line Chart from dynamic range of data
    By jason.holtzen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-17-2014, 10:50 AM
  2. Excel 2007 : Dynamic Chart Data Range
    By SuperMaths in forum Excel General
    Replies: 2
    Last Post: 11-05-2010, 09:51 AM
  3. Chart based on dynamic range
    By Chezterfield in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-15-2010, 03:52 AM
  4. Dynamic Data Range for Bar Chart
    By Juhanen II in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 05-13-2009, 09:32 AM
  5. dynamic data range chart
    By helpplease! in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-15-2007, 08:20 AM

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.6.0 RC 1