title: In google sheets, is there a way to combine columns from separate two different sheets for a pie chart?
body: <p>I have a google sheet to track my running for the year. I have <a href="https://i.stack.imgur.com/abEYW.png" rel="nofollow noreferrer">a separate sheet for each month</a>, and
  <a href="https://i.stack.imgur.com/5ql4y.png" rel="nofollow noreferrer">each sheet has my miles run each day, how long it took me, and where I ran</a>.</p>
  <p>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, <a href="https://i.stack.imgur.com/w4pm7.png" rel="nofollow noreferrer">I have a pie chart that shows me how many miles I've run at each location</a>.</p>
  <p>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 <a href="https://i.stack.imgur.com/Dt3FE.png" rel="nofollow noreferrer">chart editor</a> to enter a data range, and try to enter a range that combines the columns from more than one of my month sheets, <a href="https://i.stack.imgur.com/bwvAU.png" rel="nofollow noreferrer">it tells me &quot;One column required&quot;</a>.</p>
  <p>How do I combine the columns from multiple sheets for the data ranges for the labels/values on this pie chart?</p>