User Profile
Nezzy21
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Filtering answers from a form checklist that are not checked
Hi, I have a form with a questions as a checklist on it, but I want to create a planner task for each of the items on the checklist that was not checked off. Below is an example of the checklist: All of the items that have not been checked need to be completed and so I want them to be created as a planner task once the form is complete to these unfinished items can be addressed. Is there a way to do this with Flow/Power Automate?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 have data, the chart is plotting all 52 weeks. I only want the chart to plot the weeks as data is entered into the y axis chart. SO when data is in week 1, the chart only shows week 1 - it doesn't show all 52 weeks with one dot.Re: Trouble with Charts
ExcelonlineadvisorThank 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:
