I'll admit I'm probably doing things the hard way, but I've accomplished so much in my project so far. I've google literally for hours, I've downloaded several sample worksheets, worked through examples on websites, messed with named ranges. I assume the malfunction is on me, of course, but nothing is working for me. I have a button that records the values of several cells and copies them to another worksheet, where each row of copied values corresponds to a date/time when the user pressed the 'log' button. My sheet structure is as follows:
Sheet - Details
(user input and log button that copies specific cells into Log2 sheet)
Sheet - Log2
(500 empty rows, columns divided into various metric categories, ready to be populated with the copied values from the 'Details' sheet, empty to begin with)
Sheet - Tracking
(An overview of total progress, which is up and running just fine, and also a section where the user can see their stats from the last 10, 20, or 50 logs)
Categories Under Examination (all stored on Log2 sheet)
Col A - Date & Time
Col BR - Focus Rating
Col BT - Profit / hr
I want a line chart comparing the two values, with the dates as the horizontal axis. Conceptually, a higher focus rating would correlate with a lower hourly profit, which is the point of this particular graph. The scale is wildly different between focus rating and profit/hr, so Id move one to the secondary axis. But the chart has to be able to update whenever a user logs new stats!
When the user first uses the excel file, the Log2 sheet is empty. As they log their progress, Log2 sheet is populated and I want the charts on 'Tracking' to populate as more info is logged by the user. Since the stats on Log2 will be empty to begin with, the charts won't have any plotted points on them yet either. More importantly, I want the user to be able to define the 'range' of the most recent log times that they can view on the chart. Maybe they want the chart to display 10 of the most recent logs, or 20, or 50. I will have a predefined list of options of 'log ranges' for them to select from a dropdown.
In short, I can't work out a dynamic chart that populates as data is made available and is able to plot the X most recent points of info. (X being user selected from a list of range options).
I apologize if my explanation is making things more difficult. Thank you for your time.
-Dustin
Sheet - Details
(user input and log button that copies specific cells into Log2 sheet)
Sheet - Log2
(500 empty rows, columns divided into various metric categories, ready to be populated with the copied values from the 'Details' sheet, empty to begin with)
Sheet - Tracking
(An overview of total progress, which is up and running just fine, and also a section where the user can see their stats from the last 10, 20, or 50 logs)
Categories Under Examination (all stored on Log2 sheet)
Col A - Date & Time
Col BR - Focus Rating
Col BT - Profit / hr
I want a line chart comparing the two values, with the dates as the horizontal axis. Conceptually, a higher focus rating would correlate with a lower hourly profit, which is the point of this particular graph. The scale is wildly different between focus rating and profit/hr, so Id move one to the secondary axis. But the chart has to be able to update whenever a user logs new stats!
When the user first uses the excel file, the Log2 sheet is empty. As they log their progress, Log2 sheet is populated and I want the charts on 'Tracking' to populate as more info is logged by the user. Since the stats on Log2 will be empty to begin with, the charts won't have any plotted points on them yet either. More importantly, I want the user to be able to define the 'range' of the most recent log times that they can view on the chart. Maybe they want the chart to display 10 of the most recent logs, or 20, or 50. I will have a predefined list of options of 'log ranges' for them to select from a dropdown.
In short, I can't work out a dynamic chart that populates as data is made available and is able to plot the X most recent points of info. (X being user selected from a list of range options).
I apologize if my explanation is making things more difficult. Thank you for your time.
-Dustin