+ Reply to Thread
Results 1 to 8 of 8

chart change on my range

  1. #1
    Forum Contributor
    Join Date
    06-23-2012
    Location
    tehran,iran
    MS-Off Ver
    Excel 2010
    Posts
    179

    Post chart change on my range

    Dear all
    I show you what I want in my attach file please help me on it and show me in the file your solution.
    thanks in advanced
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,228

    Re: chart change on my range

    Hi pedjvak,

    If you do a Pivot Table and Chart and then FILTER them by the dates, I think that is what you want..??
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    06-23-2012
    Location
    tehran,iran
    MS-Off Ver
    Excel 2010
    Posts
    179

    Re: chart change on my range

    thanks for your answering to my question
    but I dont want use pivot table
    I want my user insert date in 2 cells by himself like that I show you in my file

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,228

    Re: chart change on my range

    Hi pedjvak,

    I'm sorry but I don't know how to do that. I've tried to use Dynamic Named Ranges but don't know how to limit the X axis range using two input cells.

    I'll study and see if I can find a better answer. There might be a way using VBA Code. Do you want me to follow that or will you allow VBA code to be used?
    Last edited by MarvinP; 02-03-2015 at 02:27 AM.

  5. #5
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: chart change on my range

    Hi pedjvak,
    try
    Please Login or Register  to view this content.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    06-23-2012
    Location
    tehran,iran
    MS-Off Ver
    Excel 2010
    Posts
    179

    Re: chart change on my range

    Dear nilem
    when I copy your code to my original file it is not working
    I update all of your address to what that it to be in my file
    problem is here that the name("nom" &"qnt") will not create by your code in my file
    what can I do ?
    Attached Files Attached Files
    Last edited by pedjvak; 02-03-2015 at 06:34 AM.

  7. #7
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: chart change on my range

    try to create these named ranges manually (this should be done once)
    see also attached file
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    06-23-2012
    Location
    tehran,iran
    MS-Off Ver
    Excel 2010
    Posts
    179

    Re: chart change on my range

    Thanks and hope you will safe & success

+ 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. VBA to change range of chart when end date is changed
    By mrproject44 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-25-2013, 05:04 PM
  2. Change x and y range on chart with a cell value
    By Vergil229 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-31-2013, 11:49 AM
  3. How do a create a chart that changes as I change my date range?
    By rohlfnj in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-30-2013, 04:50 PM
  4. Change the range in x axis dynamically for line chart
    By dimwit in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-27-2013, 05:23 AM
  5. How to change the range in a 2-series chart
    By guarriman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2011, 06:02 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