The concept I was missing is that the pie chart labels must be tied to a label on the spreadsheet. 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.
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. In case you want to alter the shape and make it better, press Shift and drag the shape down in the Excel worksheet. After you have selected, drag the shapes into the Excel spreadsheet templates. > you're trying to plot and I'll try to help. Next, hover the mouse on the shapes and make a selection of the desired shapes that you would like to insert in the family chart. The most commonly used combination chart type mixes a column. If not, please let me know a little more about the data Click on the Charts tab in the ribbon and select a chart type from the Insert Chart group. > 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 When you insert your pie chart, is it just with one column of data? I find
0 kommentar(er)
