Merging Tables to Calendar

[Dgreebon]

Hello and thank you for anyone willing to help. I have looked through many different websites and YouTube videos, and none seem to lead to the solution I'm looking for. I have a set of tables that when filled out, auto populate into two separate graphs. What I want to do is keep these graphs as is but add a second sheet that takes the data from the tables created and applies it to a calendar, where the user can go to a selected date and pull up the data set for that day, and auto populate the total gathered data into a set of charts for the entire year. I thank you again for anyone willing to help, and please ask me for more details if need be. I will attach what I have so far if it helps. Thank you.

[AliGW]

Welcome to the forum.

You've posted in the Access forum, but this appears to be an Excel question - shall I move this for you?

Which version of Office do you have? Do you mean Office 2016? Please update your profile. Thanks.

[torachan]

to get a better picture of what you are trying to acheive - a few comments/questions.
what is the purpose of the day/month/year sheet ?
you have two tables adjacent to each other - when manipulating tables, to prevent interactions it is good practice to have them separated by at-least 1 column/row.
This also applies to having your graphs immediately at the base of your tables.
Is it really your intention of having 365 sets of graphs and data complete and view-able ????
You would be more advised to store the data and create the graphs on-the-fly when required.
torachan.

[Dgreebon]

Yes Please

[Dgreebon]

So the data will be used to track diagnoses in Company X, I realized with this data however, that the tables already created can be used to track for the year. But, I still would like to have the ability to make a running table for daily visits and possibly monthly. I assume once I have the ability to apply the chart to the each day, I can gather the data sets in each month as well. My end idea I am working on is, having a date drop down as a subsection on the main tables, this will auto-fill the data to the date entered, which can be viewed by selecting the date desired. Once selected, a new window/sheet will open with the captured data for that day.

[AliGW]

Could you please confirm your Office version? I have moved the thread.

[Dgreebon]

The version is - 18.2008.12711.0

[AliGW]

That's an MS365 subscription - please update your profile. Thanks.