Dashboard & Chart Widgets

Is it possible to have a Chart Widget that is currently populated, maintain the same attributes (specifically the chart type and even series/colors) whenever the data source is updated?

Example - I have a sheet that lists in one column different Business Purposes. In the next column, is a formula that counts how many times the Business Purpos@row is used in a specific month on a different sheet. My intent is to show on the dashboard Chart widget, one month content in a Pie chart. Whenever I go to update the next month's content, the widget seems to default back to a Line chart type. I am not wanting to have to touch every dashboard widget attribute such as the chart type every single month.

Is there a better way to organize the data to default the chart into a Pie chart?


Best Answers