Share via

Pie Chart not displaying

Anonymous
2016-09-22T06:48:38+00:00

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?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2016-09-23T02:23:03+00:00

    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.

    100+ people found this answer helpful.
    0 comments

8 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-09-23T00:56:32+00:00

    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.

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2016-09-22T17:43:34+00:00

    Yes, Labels in the left, values in the right. Here's a screenshot of what I get and how I start.

    7 people found this answer helpful.
    0 comments
  3. triptotokyo-5840 36,681 Reputation points Volunteer Moderator
    2016-09-22T19:22:08+00:00

    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?

    You don't say which version of EXCEL you're using neither do you say exactly how you are selecting the non adjacent ranges. 

    Using the data that you have provided in EXCEL if I hold down the CTRL key and then highlight the ranges:-

    A2:A6 (Salaries and Benefits down to and including Miscellaneous) 

     - and:-

    F2:F6 (3,106,284 down to and including 904,067)

     - and then insert the Pie Chart it opens correctly:-

    2 people found this answer helpful.
    0 comments
  4. Anonymous
    2016-09-22T11:08:39+00:00

    Hi,

    It should work fine. 

    Are your data labels in the left hand range, and the values in the right hand range? Could you share your worksheet?

    Thanks

    Tom

    2 people found this answer helpful.
    0 comments