yogi_SetUp A Single Chart To Show Dynamically Via A dropDown Data For WeekNumber WeekDay Or AllDays

Google Spreadsheet   Post  #2206

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-10-2017

question by Sam Larimer:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/GNagREZr_Lc;context-place=mydiscussions

Using Data Validation for dynamic chart with different size range

I may be blindly searching for a how-to that does not exist, but is it possible to use data validation, formula in charts, dynamic ranges, etc. to create a dynamic chart that measures the same quantities but over different lengths of time?

Document in Question: Chart w/ Dynamic Range

Basically, I'm attempting to create a single chart that measures a float ratio and displays a month's data points by:

• date in month
• day name
• weekly average

However, all this data in one place would be very cluttered and/or useless for comparison. The next best option in my mind is a data-validation to choose which data range is pulled for the chart.

Chart type isn't too important. I have faith in you experts, but let me know if this is a wild goose chase