Metric sheet - can you create a chart off two different sheets on metric sheet

I have active project sheet and a separate pipeline project sheet.

I have a metrics sheet that includes data on the active sheet. I see that I can create metrics from pipeline sheet in different columns. But what I want to do is create a chart based off the metrics from both. So Ideally I would like project by status and include the following. The pipeline info is from the pipeline sheet. I can't remove the columns in between b/c I am using them for other formulas.