+ Reply to Thread
Results 1 to 4 of 4

Dynamic Chart

  1. #1
    Registered User
    Join Date
    11-28-2014
    Location
    india
    MS-Off Ver
    7
    Posts
    139

    Dynamic Chart

    Hi all

    I followed the steps from this thread: http://www.excelforum.com/excel-char...ro-values.html
    and prepared the attached sheet
    but when I try it in multipal sheet its giving some error .
    I have tried all possible solution from my end now looking for your kind help in my attached sheet.
    in both the sheet I have applied the formula for CT and OCT graph ( as per dynamicbased on Countif.xls‎ of the above link )but whenever I put some data it throes some error.
    also the Horizontal (Category) Axis Labels is not reflecting

    please look into this mater ,it will be a great help.
    I have to add total 8 sheet bot now I have attached only 2 sheet .once it resolved i can add the rest sheet.

    looking for your quick support.

    Regards

    Arindam
    Attached Files Attached Files

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Dynamic Chart

    Hello,

    all the range names are using Offset() and they are a tangle of interwoven, dynamic range names. Start the cascade of dynamic names with at least one range name that refers to a worksheet range. Then Offset from that.

    cheers, teylyn

  3. #3
    Registered User
    Join Date
    11-28-2014
    Location
    india
    MS-Off Ver
    7
    Posts
    139

    Re: Dynamic Chart

    So you mean to say for multiple sheet I shouldn't add multiple "Define Name"
    "Define Name" should be added only once for the entire workbook???

  4. #4
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Dynamic Chart

    Nope, scratch that.

    The problem is the range name CT. It resolves with an error,
    because the Countif in the Offset returns a zero,
    which is because the range $AO$45:$AO$56 on the first sheet is empty,
    which is because the cells AO26 to AO37 which that range refers to, is empty,
    which is because the cells U34, U46, U58, etc, which these cells refer to are all empty.

    I stopped after that. There may be other range names that have errors.

    That is the reason for the error message and the reason why the charts don't work.

    Start from the top of your logic and go through things with a fine tooth comb. Ensure that there is always sufficient data so dynamic range names don't return errors.
    Last edited by teylyn; 09-16-2015 at 05:13 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] dynamic chart values formula with dynamic starting point
    By Kramxel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-24-2015, 03:30 AM
  2. Wants to Create Dynamic Chart basis on Dynamic Table
    By Nisha Dhawan in forum Excel General
    Replies: 6
    Last Post: 04-30-2015, 12:08 AM
  3. Replies: 1
    Last Post: 04-10-2015, 11:53 AM
  4. VBA - Updating Dynamic Line Chart & Inserting Dynamic Formula
    By bruno08102013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-09-2014, 10:10 AM
  5. How to create a dynamic chart off dynamic data
    By jananas in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-07-2013, 10:48 AM
  6. Dynamic Range Column Chart w/ Dynamic Avg Line (Excel 2007)
    By BrokenBiker in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-04-2012, 11:40 AM
  7. Can I create a dynamic chart with a dynamic number of series?
    By SG2 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-24-2011, 08:44 AM

Tags for this Thread

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