I just want to tell everyone that with the additions of the chart widget, I am really loving our dashboards.
I do wish the legends were editable and the selections didn't have to be side by side.
I got around this by creating a second sheet and linking cells to the needed data. I could then create the labels I need and use one sheet to put data side by side into columns. I do have to repeat columns to get the data to be used for other charts, but having this new widget is worth it.
THANKS A MILLION!