Excel scatter plot assistance please

I thcurrently have a scatter plot setup to pull data from 3 tables that are located on 3 seperate tabs. What I'm looking to do is to setup a drop down menu that has all the months. Upon selecting a month I would like the x axis to display the days of the month. For example if I select november I wan 11/1, 11/2, 11/3... and so on the display.

post an example workbook. The important items are the chart and data layout you currently have.

Attached is an example of the workbook. To be honest I'm a newb and it took me forever to figure this much out :-)

Also, it doesn't necessarly have to be a drop down menu it could be command buttons or whatever else that could potentially work.

Without any data at all I can not determine how you chart was dealing with the data.

Instead of plotting the Y data from the current columns you could add additional columns that contain formula. The formula would check the Date value for each row is within the month selected. If it is the original Y value is used if not NA() is used instead.

The Data makers for the NA() data points will not be displayed.

You may also need to adjust the Min/Max X axis values to display relevant month only.

Hi Andy,

Thank you for the response. I will attached another document that contains data.

I'm not sure if I'm not 100% understanding you or if I didn't explain what I'm looking for properly. Essentially what I'm looking for is a code/macro that will auto update the X-axis to reflect a specific month. I want every day of the month to display. Currently, every month I have to manually change the X-axis min. and max. specifications to match the current month. I'm looking for a way to make this process automated. Please let me know if this makes sense. Thanks.

So would I be correct in assuming that the data in the 3 sheets is only for a particular month and that all you need to do is update the min/max of the scale?

Assuming macro to set axis

Please Login or Register  to view this content.

asking the user to enter a month number. Then setting the min to the first of that month and the max to the last.

You may not want to get the value via an input box so you may need to modify the code to run from a cell change where the user picks the month.
Or a formula that determine the month from the data on one of the worksheets.

How you get the user to provide the information is more up to you than me to decide

Here is an example with the code used in conjuction with a data validation list on the first of the 3 data sheets.