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

Shawn Borror

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.

Paul Newcome

I'm not sure I follow. Are you trying to add the Project by Status fields and the Pipeline field together?

ron.judenberg112096

Perhaps you could move the pipeline information just above or below the project statuses?

Pipeline 15

In Progress 14

Hold 3

Complete 1

Then you just make a chart with 4 values.

Shawn Borror

I tried just below and the formulas above that reference the ACTIVE project sheet links changed to the PIPELINE project sheet. I had to move to it's own columns but the chart counts the columns. I feel certain there is another way. (BTW, I got the metrics/rollops from the webinar on dashboards)

Paul Newcome

Are you able to provide a screenshot with manually entered data that reflects what you want the outcome to be?