The concept I was missing is that the pie chart labels must be tied to a label on the spreadsheet. While you are there, you may also try use a different group field in Google Chart. Your suggestion led me to try another way of creating the chart that works: Insert Chart, select the label cell on the spreadsheet, select the data cell it corresponds to, repeat for each instance of label/data and then select the pie chart control from the elements gallery to create it. Highlight the data you want to present in the pie chart, including the labels, by dragging. Try rearranging the fields in the views settings under Fields section. The data is separated from the labels in the first column and only certain data values in the columns(totals) are used in the pie chart, not the whole column(for instance M5, M10, M15). It is one that grows columns to the right-hand side over time. > you're trying to plot and I'll try to help. How can I make an Excel chart refer to column or row headings Click on the chart to select it. Select the chart type you want to use and the chosen chart will appear on the worksheet with the data you selected. ![]() Then click the Insert tab, and click the dropdown menu next to the image of a pie chart. If not, please let me know a little more about the data To create a pie chart in Excel 2016, add your data set to a worksheet and highlight it. The single column column B used to create the excel pie chart is reflected under series Select or deselect the categories in order to show or hide them from the chart. > legend labels and column B for the data. ![]() > and I select both and create a pie chart that way, it uses column A for the > that if I have one column (A) of labels and a second column (B) of labels Enter the following data into your expenses workbook. When you insert your pie chart, is it just with one column of data? I find Creating a Pie Chart Open a new workbook in Google Spreadsheets.
0 Comments
Leave a Reply. |