I have a pivot sheet with all of the data formatted the way I need it but when it refreshes it pulls columns back in that are not needed which impacts a chart within my dashboard. Any suggestions? Thank you.
What if you created a Report that's based on this Pivot sheet? That way the Report could bring in the columns required for the chart on your dashboard, ignoring any other columns in the sheet.
Keep in mind that when Reports are used as the source data for charts, the entire Report is selected (you can't specify a selection of cells like in a sheet), so you may want to use the filter function to ensure that the correct information is being shown.
Let me know if this works for you!