Announcement

Collapse
No announcement yet.

Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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
    Re: Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets

    Hi,

    If you can upload here, pl. upload it.
    Kris

    ExcelFox

    Comment


    • #3
      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.

      Comment


      • #4
        Re: Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets

        Save as and Zip it.

        Comment


        • #5
          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
          Kris

          ExcelFox

          Comment


          • #6
            Re: Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets

            Hi,

            Final version.

            Edit: got the payment.

            Thanks Carl
            Attached Files
            Kris

            ExcelFox

            Comment

            Working...
            X