+ Reply to Thread
Results 1 to 3 of 3

How to automatically draw a graph with wanted time periods?

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    Helsinki
    MS-Off Ver
    Excel 2010
    Posts
    34

    How to automatically draw a graph with wanted time periods?

    Im creating an excel tool for many people to use and I want to make it as automatic as possible.
    I have the following data and I have drawn a graph using the whole data, which is easy to make automatic.

    excel example.xlsx

    Is it possible that the next person could somehow choose the time periods that s/he wants to use in the graphs without actually doing the graph again and choosing manually the time periods and data to be drawn? I have also added the graph that I want the excel to draw automatically.

    So basically the person would specify the time periods s/he is interested (in the example: P1/10-P10/10) and only these would be plotted and also the other timeperiods in the data would be left out from the x-axel.

    Thanks for all the help!

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: How to automatically draw a graph with wanted time periods?

    What you are looking for is dynamic charts..This will get you started..

    http://www.excelforum.com/excel-char...el-2003-a.html
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    06-26-2012
    Location
    Helsinki
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: How to automatically draw a graph with wanted time periods?

    Thanks for the quick reply!

    The problem here is that it starts to draw automatically from the beginning of the year but it might be that I want it to start later.. but at the same time end earlier than I have data for just like this dynamic charting would do..

    Is there a way excel could recognize the value in this case time period to know when to start and when to end, if these were manually written in a separate cell and used in the formula to draw the graph?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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