Results 1 to 4 of 4

Dynamic chart - Show last 3 data inputs

Threaded View

Kartoffelmos Dynamic chart - Show last 3... 10-20-2014, 04:21 AM
misrasomendra Re: Dynamic chart - Show last... 10-20-2014, 05:21 AM
Kartoffelmos Re: Dynamic chart - Show last... 10-20-2014, 05:29 AM
misrasomendra Re: Dynamic chart - Show last... 10-20-2014, 05:31 AM
  1. #1
    Registered User
    Join Date
    05-25-2013
    Location
    denmark
    MS-Off Ver
    Excel 2010
    Posts
    52

    Dynamic chart - Show last 3 data inputs

    Hi i want to create a chart that shows the last X data, and i want to be able to select X=2 or X=5 etc.


    --A---:---B---:---C---:
    Months: Data 1: Data 2:
    Jan----:--5---:
    Feb---:---0---:
    Mar---:---3---:
    April---:---2--:

    so for chart (Data 1)
    i want to be able to select last 3 Data, and it should skip 0 or ignore it and not display it in the graph

    thanks!
    Last edited by Kartoffelmos; 10-21-2014 at 04:09 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Chart with dynamic data in a row, account valid data only when building chart
    By artmak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-05-2014, 02:21 PM
  2. 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
  3. Best way to sort and sum dynamic data, compare to other data and show differences
    By williery10 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2012, 10:32 AM
  4. Extracting Chart Data and Adjustable Inputs through VBA
    By maani in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2009, 04:37 AM
  5. function w/ dynamic inputs
    By tadwegner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2008, 12: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1