+ Reply to Thread
Results 1 to 4 of 4

How to change X axis range using dynamic ranges

  1. #1
    Registered User
    Join Date
    08-10-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    14

    How to change X axis range using dynamic ranges

    Hello,
    i have been building a worksheet where i want user to enter start & end period for which data should be visisble on a chart.
    i made two dynamic ranges one for sales data other for period using offset & match formulas.
    as a second step i am changing series in a line chart with these ranges. While ranges for data is working on chart. For labels its giving an error that "formula in this worksheet contains one or more invalid references. Verify that formula contains valid path, workbook,rangename, & cell reference......"
    Can you please help in solving this mystry for me
    Attached is the example
    Thanks
    KT
    Attached Files Attached Files

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: How to change X axis range using dynamic ranges

    Hi,

    The OFFSET function in your Chtlabels name has a height of 0. I believe it should be 1.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Registered User
    Join Date
    08-10-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    14

    Smile Re: How to change X axis range using dynamic ranges

    Thanks a lot. Its resolved

  4. #4
    Registered User
    Join Date
    08-10-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: How to change X axis range using dynamic ranges

    actually i have sales of 8 products in three different countries. So setting ranges for each product in each chart is tedious & this way has increased the size of my dashboard.
    Can anyone suggests a better way without using VBA?

+ 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] Dashboard help needed. Need chart axis to change based on date ranges.
    By mcranda in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-18-2013, 10:30 AM
  2. Dynamic Ranges Change When Used by VBA
    By Bulkhead in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2012, 01:30 PM
  3. 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
  4. Change code so that Dynamic ranges include sheet name
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-02-2011, 03:51 PM
  5. Replies: 2
    Last Post: 02-02-2006, 04:10 PM

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