Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trying to create an exploded pie with labels and values on the chart.. 1
- Thread starter Paladyr
- Start date
-
1
- #2
I'm not sure what your question is.
Right-click the chart, choose chart options, go to legend tab and choose not to show the legend.
Right-click the chart, choose chart options, go to legend tab and choose not to show the legend.
- Thread starter
- #3
I want to create an exploded pie graph with labels (what would appear in the legend) as well as values ON the chart (not having labels in the legend, rather on the chart with the values). It gives you the option of showing %'s and labels, but not values and labels. I don't want to use the legend since excel 2000 can only support 10 black and white pie areas and a legend would be useless when printing in B&W.
Thanks for the reply.
Thanks for the reply.
I see.
Looks like you will have to do either the labels or the values manually with text boxes.
Sorry. Perhaps someone would write the code.
Looks like you will have to do either the labels or the values manually with text boxes.
Sorry. Perhaps someone would write the code.
- Thread starter
- #5
I'm not sure how you could code this to do anything different?
I tried making the source data something like:
="Label - " & B6/A3
But it needs to have just a numeric value there to graph it properly. Also, I don't think it will let me add text boxes to the graph (i can only add them outside the graph area).
Seems like Microsoft could've done something very simple like instead of linking the graph to the legend with colors, they could do it with numbers for just this occasion, where it couldn't provide enough B&W patterns and doesn't allow you to put the labels as well as the values in the pie area. Oh well... i'll keep looking.
I tried making the source data something like:
="Label - " & B6/A3
But it needs to have just a numeric value there to graph it properly. Also, I don't think it will let me add text boxes to the graph (i can only add them outside the graph area).
Seems like Microsoft could've done something very simple like instead of linking the graph to the legend with colors, they could do it with numbers for just this occasion, where it couldn't provide enough B&W patterns and doesn't allow you to put the labels as well as the values in the pie area. Oh well... i'll keep looking.
I just put a text box directly on top of a pie chart. What happens when you do this? Perhaps you need to right-click the textbox, hit Order and tell it to bring it to front. Also, if you've got the pie on its own chart page, I don't think you can use textboxes. Hit Chart-Location and move it to be included with the data sheet.
- Thread starter
- #7
. I'll give that a try and see how it looks, thanks!- Status
Similar threads
- Locked
- Question