+ Reply to Thread
Results 1 to 4 of 4

Create a dynamic chart based on range that contains formulas

  1. 10-09-2018, 07:50 AM #1
    leprince2007
    leprince2007 is offline
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    Create a dynamic chart based on range that contains formulas

    Hello everybody,
    Can you help me in this problem,please?
    I need to create a dynamic chart based on range that contains formulas but failed.
    I created range names using offset formulas but the chart looks wrong-See Name manager
    The chart in my file is for product A only for supplier AAA
    Find the attachment
    Waiting your feedback
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-09-2018, 08:14 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: Create a dynamic chart based on range that contains formulas

    Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    and
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    for AAA_Dates and AAA_ProductA respectively.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 10-09-2018, 08:31 AM #3
    leprince2007
    leprince2007 is offline
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    Re: Create a dynamic chart based on range that contains formulas

    Thanks a lot
    the problem solved
    Reply With QuoteRegister To Reply
  4. 10-09-2018, 08:47 AM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: Create a dynamic chart based on range that contains formulas

    You're welcome. Thanks for the rep.
    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)

Similar Threads

  1. [SOLVED] Dynamic chart from a range containing formulas
    By chrismeeky in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-01-2018, 05:39 PM
  2. NEED HELP!! Looking for a way to extract data from a growing range to create dynamic chart
    By danemorel in forum Excel General
    Replies: 5
    Last Post: 05-06-2018, 11:38 AM
  3. [SOLVED] Create a dynamic chart with ranges generated from formulas
    By BRISBANEBOB in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-09-2016, 04:31 AM
  4. [SOLVED] create chart using dynamic range (Indirect Function)
    By umbata in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-08-2015, 10:37 PM
  5. How to use a dynamic range with OFFSET to create a chart in separate workbook
    By JTM1200 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-12-2012, 06:32 PM
  6. how to create dynamic chart range when 1 axis is constant
    By jrtaylor in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-14-2011, 06:26 PM
  7. macro to create pie chart based on dynamic ranges
    By jarssonn in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-04-2010, 11:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1