Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets

  1. #1
    Join Date
    11th December 2008
    Posts
    2

    Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets

    WILLING TO PAY $25 to $40 for SOLUTION

    I am building a workbook in Excel 2007 which has a dashboard page that will display a number of charts and graphs. These charts and graphs will be dynamic in nature, with the series being built using Named-Ranges built with the OFFSET function. The data set consists of a number of data elements entered per day, by employee.

    I successfully built an example graph that does the comparison of two series for each of the 30 or so different data elements that are entered for the particular data set. The data set may start on a random date and may end on a random date (different employees my start or stop work on random dates). I have drop down lists that correctly build the Named Ranges for the "Element to Chart", the "Month to Chart" and the "Month for Comparison".
    *note: there is a slight issue here with this example graph in that the first number in the data series for the X axis is being evaluated as a "0" instead of what the named range actually shows, so the series is 'offset' by one day.

    So this example chart is very close to doing the job perfectly.

    My plan is to use multiple worksheets in a single workbook that allow for multiple employees. Then to build an employee list based on the number of 'employee data input worksheets' which also contain the employee's name.

    I have correctly built a dynamic range, and a drop down list that lists the employee names. What I am trying to do is have this list (call it the "Employee to Chart" list) work in conjunction with the aforementioned controls (Element to Chart, Month to Chart, Month for Comparison) such that the dynamic lists and ranges that are displayed in them are specific to the data that is in the 'employee's worksheet.

    In other words, even though the data elements are all the same for each employee, the work dates and thus the time frames available for comparison will be different. So as I choose the employee, the months for comparison lists have to be built by the specific data in the employee specific worksheet, as does the data set that will be displayed in the graph.

    Currently the workbook structure is Ratios.xlsx - Dashboard(worksheet), Data-Emp1(worksheet),Data-Emp2(worksheet), etc.

    I can send the speadsheet if anyone can help.

  2. #2
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,678

    Re: Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets

    Hi,

    If you can upload here, pl. upload it.

  3. #3
    Join Date
    11th December 2008
    Posts
    2

    Re: Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets

    Here is the file. The data set is not completely full, but there is enough data to get the idea I think.

    For some reason it says the file is invalid. My guess is that it doesn't like the xlsx extension.

    I will email the xlsx version and xls compatible version as the Xls version is too large to upload.

  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,798

    Re: Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets

    Save as and Zip it.

  5. #5
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,678

    Re: Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets

    Hi Carl,

    See attached. Let me know how it work for you.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  6. #6
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,678

    Re: Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets

    Hi,

    Final version.

    Edit: got the payment.

    Thanks Carl
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Using Dynamic Ranges in Charts
    By Shakeel in forum Excel General
    Replies: 12
    Last Post: March 22nd, 2006, 05:48
  2. Dynamic ranges on charts
    By Doodlebug in forum Excel General
    Replies: 7
    Last Post: February 23rd, 2006, 23:37
  3. Dynamic Ranges and Charts
    By Biz in forum Excel General
    Replies: 9
    Last Post: February 18th, 2006, 10:38
  4. Dynamic charts and named ranges
    By Akuma99 in forum Excel General
    Replies: 2
    Last Post: July 7th, 2005, 22:51
  5. [Solved] Charts: Dynamic Ranges
    By thursfip in forum Excel General
    Replies: 4
    Last Post: December 9th, 2003, 05:06

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
  •  
porno