Is there a way to change the chart data based on a cell input? I am trying to have a chart change to show the current months data when I enter the month in an assigned cell. When I enter a month in cell A1 on the first sheet I want the data for that month to show in the chart.
Bookmarks