Metric Widget Column Header
I am trying to grab data from my dashboard metrics sheet in such a way that data is associated with the selected column header, as opposed to the actual column header. I am trying to use the Metric Widget like how I use the Chart Widget, but am getting results like in the screenshot, attached, where the heading I am looking to use is added as data under the column heading and the data I wan under the heading I am looking to use is added under the column heading also.
Metric 1: % Complete
Metric 1: 38%
% Complete: 38%
This is easily accomplished utilizing the Chart Widget. Is this possible utilizing the Metric Widget?
Thank you for your help and input.