Pie Chart not displaying

Question

I'm trying to create a pie chart. When I select two nonadjacent ranges and then click to select the pie chart, it doesn't display. I get a chart with my first range of data showing as a title and that's it. Help?

Answer 1

Hi, you can try another way to insert the pie chart into your "Blank Pie Chart Box" area as you have shared.

Assume that, Your table range is A1:F7, Where A column is chart "Series Name" and F column is "Annual Total"

Step 1: Select your pie chart title and press "Delete". Now it will looks like below:

Step 2: Now Right click in your pie chart area box and select "Select Data". This will show you a dialog box.

Step 3: Click on "Add" button and fill the "Edit Series" dialog box as below and click on "OK".

Now to Add the Legend Title follow these steps:

Step 4 : Click the "Edit" button under "Horizontal (category) axis Labels" of this dialog box.

Step 5: A new dialog box appears named "Axis Labels". Fill it up by selecting the A2:A6 cell. It will looks like below and press "Enter" and click on "Ok" twice to close 2 dialog boxes.

After closing dialog boxes it will looks like below:

Now add legend or chart title by clicking on "+" sign after selecting the chart or others modification whatever you need. And then it will looks like below:

Hope this will help you.

Answer 2

Hello,

if you do this:

• select A5 to A9
• Ctrl click F5
• Ctrl click F6

- Ctrl click F7

- Ctrl click F8

- Ctrl click F9

and insert a pie chart, then Excel will create the chart you show in your screenshot above. With all the individual cells clicked, Excel can't determine which cells hold the series data. It will treat A5 to A8 as the series name, A9 as the series value, ignore everything in column F and apply a number 1 to the axis label / legend. You can see this when you select the chart and see the data highlighted in the worksheet. Also, select the chart and edit the data source, edit the series. 

If, however,  you do this:

• select A5 to A9

- Ctrl click F5 and drag down to F9

then the pie chart will display correctly.

Answer 3

Except I have been selecting the correct way as you said. I select A5 to A9 then control click F5 and drag down to F9. And I get the funky chart.

So it's either a software or keyboard issue maybe.

Answer 4

Okay I'm going to try this. I'll let you know if it works

Answer 5

It worked. My thanks!