CODEWITHSUNDEEP
google-sheetspie-chart
misterbuckley
misterbuckley

Reputation: 13

In google sheets, is there a way to combine columns from separate two different sheets for a pie chart?

I have a google sheet to track my running for the year. I have a separate sheet for each month, and each sheet has my miles run each day, how long it took me, and where I ran.

I have another sheet that takes data from all the month sheets and aggregates it to give me stats for the whole year. On this sheet, I have a pie chart that shows me how many miles I've run at each location.

My problem is, I can only give the pie chart data from one of the month sheets, because it will only accept a single column for the data ranges for the labels and the values. If I click on label or value in the chart editor to enter a data range, and try to enter a range that combines the columns from more than one of my month sheets, it tells me "One column required".

How do I combine the columns from multiple sheets for the data ranges for the labels/values on this pie chart?

Upvotes: 0

Views: 5110

Answers (1)

player0
player0

Reputation: 1

you cant do this directly in the chart editor. you need to create a sheet where you will use QUERY or FILTER to get all data from your monthly sheets and then you can make chart from it.

something like:

=QUERY({Jan!A2:F; Feb!A2:F; Mar!A2:F; Apr!A2:F; May!A2:F; Jun!A2:F; 
        Jul!A2:F; Aug!A2:F; Sep!A2:F; Oct!A2:F; Nov!A2:F; Dec!A2:F}, 
 "where Col1 is not null", 0)

Upvotes: 1

Related Questions