Forum Discussion
Nezzy21
Nov 30, 2023Copper Contributor
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 ...
- Dec 01, 2023
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.
Nezzy21
Nov 30, 2023Copper Contributor
Excelonlineadvisor Thank you. I realize I made an error in my original message and got the x and y axis backwards. I'll edit to fix. I hope my explanation and photos below can add some clarity. I added the formulas as you described, but I'm still seeing all of my X Axis and I only want to see the X Axis as data is entered into Y. Below is how it currently looks:
Because I only have up to week 5 entered in the 'Meat' column (my y axis), I only want the chart to display up to Week 5 as the image below:
Patrick2788
Dec 01, 2023Silver Contributor
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.
- Nezzy21Dec 04, 2023Copper ContributorWow! This is perfect! Thank you!
- Patrick2788Dec 05, 2023Silver ContributorYou're welcome!