I can't see your images either. This happens sometimes, no fault of your own.
When you click on a chart, it shows you where it is getting the data. That is what you are seeing in your table, the data highlighted and showing you which color is which series of data. But a chart should have a legend of some kind unless it is not necessary for understanding the chart.
You can readjust the invisible box that surrounds the legend and move it to the side:
You can turn off the legend and instead show the categories (series names) on the chart:
I forgot to set the format of the labels to dollars (instead of percentages) in those two screenshots.
Currently Being ModeratedJan 16, 2013 9:03 AM (in response to Badunit)
Thanks for the responses. Here are the images in JPG format. Hopefully that works better than PNG.
THIS IS WHAT I WANT. On the same page I need to show the category, dollar amount and the percentage in the pie chart. The colors and legend showing only show up when I click the pie chart. If I click off or print, the legend disappears.
THIS IS WHAT I DON'T WANT. I have to show legend which shows at the bottom but it is the same descriptions in the spreadsheet. I am extremely limited on page space since I have like 18 true categories to show. Therefore, I need to make the pie chart as large as possible.
Thanks again or all of your responses. I have very grateful.
The colors and legend showing only show up when I click the pie chart. If I click off or print, the legend disappears.
That is becasue it is not a "legend" it is a tool for creating and editing charts.
I can't think of an automated way to recreate the legend without it being a legend but here is a shot at it:
I used a color fill for each of those colored cells, picking the color off of the circles in the actual legend, which I turned off after I was done.
If you want it to look exactly like your screenshot, good luck. It took a lot more manual work to get it to look close:
Currently Being ModeratedJan 16, 2013 2:16 PM (in response to Badunit)
Your solution will work, but I am actually setting this up as a template for a non technical user. Therefore I was hoping it would dynamically update if new rows were added.
However I think only the dollar figures will change in the near future so I might do this as a workaround.
Still open to other suggestions, but thank you.
Numbers always uses the same colors, unless you change them manually. So, as long as you have the same number of categories (or hide rows that are empty) and never sort the table, it can work.
I'll keep thinking. I might be able to make it more automatic for you.
See if this gets you started
I put the legend in a separate table that consists of a single column. The column contains formulas that refer to the data table (Table 1). The formulas are not affected by sorting the data table, you can sort it all you want and the legend will be correct. I filled each cell with color and used conditional formatting to make it white text on a white background if there is no header text for that row. I also made the borders white so they would blend into the page. Add text in one of the empty rows of the data table and you'll see how it acts.
Notice that a pie chart has only six different colors, then the colors repeat. You can modify that but you'll also have to modify what I did by changing the legend cells to the the new colors. I changed the colors by turning on the legend, using the magnifying glass in the Color window to get the color, then drag/dropping the color on the cell. I do not know how many different colors you can use.
I recommend locking the legend table so it cannot be modified by the user.
I recommend turning Wrap off in the data table. If text wraps it makes the row taller which will cause the legend and the table to become misaligned. Changing the font, changing rows sizes manually, or moving the table will do that too.
I recommend locking the chart so it cannot be modified by the user.