names in pie chart

Question

Nick Savas Author

Level 1

137 points

names in pie chart

Now That I Mastered The Scatter And Line Charts (With Your Help) I Advanced Myself To The Pie And Column Chart

Started A New Chart
Went To And Selected The (CHARTING BASICS TEMPLATE) (Looks Simple Enough). I Studied It Carefully. I Replaced The Data With My Mine Data And Chart Worked Fine.
The Table Looks Like A Simple Basic (WITH ROW HEADERS ONLY)
I Reduced The Table To Meet The Needs Of My Data
Column (A) In Sample Is Formatted As (TEXT) No Problem
Column (B) In Sample Is Formatted As (AUTOMATIC)
Best Of My Knowledge I Copied Everything Exactly As Displayed In Template.

I Inserted And Clicked On Pie Chart To Bring Up The (EDIT DATA REFERENCES) After Making Sure I Had Setting At Bottom Selected As (PLOT ROW AS SERIES)
You Can See By My Attachment Everything Was Selected In The Table.
The Numbers Were Displayed In The Pie Chart But I Keep Getting UNTITLED For The NAMES.

Don’t understand why something supposedly simple I giving me a hard time.

iMac, Mac OS X (10.7.5), El Capitan (Version 10.11 Beta)

Posted on Nov 3, 2015 6:22 AM

Reply

Answer 1

SGIII

Level 8

37,562 points

Nov 3, 2015 7:03 AM in response to Nick Savas

Note how column A is shaded here:

Column A must be defined as a Header Column.

If it's not a Header Column, you can convert it like this:

SG

Reply

Answer 2

Nick Savas Author

Level 1

137 points

Nov 3, 2015 8:23 AM in response to SGIII

Your Suggestion Worked. I Guess You Are Telling Me I Should Have Used The (Headers Table.) I Did Try That 1St But I Guess I Must Have Screwed Up Somehow.

I Started From Scratch This Time And Your Advice Worked Fine But I Noticed After I Clicked On The Pie To Bring Up The (Edit Data Preferences) I Had To Click On Each Row To Make The Column (A) Valid And Workable. I Was Under The Impression All I Had To Do Was Just Make Contact with the TABLE

Reply

Answer 3

SGIII

Level 8

37,562 points

Nov 3, 2015 8:56 AM in response to Nick Savas

Nick Savas wrote:

I Was Under The Impression All I Had To Do Was Just Make Contact with the TABLE

Hi Nick,

I think we all have developed different habits when we make a chart. There are different ways to do the same thing. However, when I make a chart, I generally find that what works best for me is to first select the cells (in my example, A1:B5 or the entire column A and column B) and then (with the cells still selected) go the toolbar or the menu to insert the chart.

Thanks for the green tick!

SG

Reply