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
No comments:
Post a Comment