+ Reply to Thread
Results 1 to 2 of 2

Dynamically Create Graph Based On Month Selection

  1. 03-24-2015, 12:01 PM #1
    ExcelJeffrey
    ExcelJeffrey is offline
    Registered User
    Join Date
    03-24-2015
    Location
    Florida, USA
    MS-Off Ver
    2013
    Posts
    1

    Dynamically Create Graph Based On Month Selection

    I am building a dashboard and I want to include a line graph that shows the trend for each statistic in the dashboard. I would like the graph to show a rolling 30 days.

    For example, Revenue is a statistic shown in the dashboard. I have a data table that includes the revenue for every day. I want the line graph to show revenue for the last 30 days, starting with today.

    How can I have the "Series" that the chart is using to build itself dynamically change? Can I use variables or lookup functions within the series?
    Reply With QuoteRegister To Reply
  2. 03-24-2015, 05:40 PM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Dynamically Create Graph Based On Month Selection

    Try using approach described here: http://chandoo.org/wp/2009/10/15/dyn...t-data-series/
    Best Regards,

    Kaper
    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. Macro to create graph up to current month
    By danfullwood in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2014, 04:12 AM
  2. [SOLVED] Dynamically create columns for each month
    By mgoutam in forum Excel General
    Replies: 2
    Last Post: 03-13-2014, 08:24 AM
  3. Dynamically create checkboxes based on listbox selection
    By IAmNomadic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2013, 05:36 PM
  4. VBA for Updating Cell validation dynamically based on the RadioButton Selection
    By Rem0ram in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-24-2012, 03:14 PM
  5. Using data to create a graph organising frequency by month.
    By mcpoogle in forum Excel General
    Replies: 5
    Last Post: 10-12-2011, 11:58 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