May 02 2022 03:58 AM
Hi
I'm trying to create a pie chart by selecting data from two different columns. However, it's only displaying the values from the first column. I do not need the titles just the numbers reflected in the chart. For how I need it layed out as well it needs to be two columns. Below is an example.
May 02 2022 04:08 AM
Use copy/paste or formulas to create a contiguous range with the values. In the screenshot below, I placed that range next to the original data, but it can be elsewhere, even on another sheet.
Use the contiguous range as source for the chart.