Monday, July 10, 2017

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