Forum Discussion
Trouble with Charts
Hello - I am trying to set up a chart that updates dynamically based on the value of one column (y axis). I need to have the week 1-52 in the second column (x axis), but because those cells already ...
Here's a demo that may work for you:
The trick with the dynamic ranges is to have the 'height' of both determined by the 'Meat' column. Also, it's ok to use OFFSET for the dynamic items for charting purposes. Charts do not take kindly to dynamic items created with TAKE.
Here's a demo that may work for you:
The trick with the dynamic ranges is to have the 'height' of both determined by the 'Meat' column. Also, it's ok to use OFFSET for the dynamic items for charting purposes. Charts do not take kindly to dynamic items created with TAKE.
Wow! This is perfect! Thank you!
- You're welcome!