matttclark
Board Regular
- Joined
- Jan 13, 2011
- Messages
- 100
Hello,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have a pie-in-pie chart that the client wants to see the ‘value’ and the ‘category name’ in the data labels. I am actually using financial data but to keep the terms simple I’ll use a pet store example. Say I have sales figures for lizards, fish, birds, hamsters and rabbits. The client wants the small pie to contain a specific set of data, so I have manually dragged the slices between the small and large pies so that the sales of lizards, fish and birds are in the large pie and the hamsters and rabbits in the small pie. On the large pie each value shows its category name (hamsters, etc.) and $$ except the parent slice of the small pie which shows “Other” (excels default value) and the total $$ for the small pie (hamsters and rabbits). The client would like the name to say “Mammals” instead of “Other” which I can manually edit in that data label, but then some link gets broken to the underlying data. Now any changes to the source data will not update in the parent slice (the small pie works fine). I have tried a couple of options to resolve this… a) turn labels off, update the data, turn back on, manually overtype the “other” label b) tried to make only the category name text in the parent slice white so it wouldn’t show, then place a text box over it with the word “mammals”. None are really satisfying. Any suggestions? Is there an automation way to do this, a macro to accomplish a) above, or a way to get under the covers to change the default value of other? This would have to be workbook specific of course
<o></o>
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have a pie-in-pie chart that the client wants to see the ‘value’ and the ‘category name’ in the data labels. I am actually using financial data but to keep the terms simple I’ll use a pet store example. Say I have sales figures for lizards, fish, birds, hamsters and rabbits. The client wants the small pie to contain a specific set of data, so I have manually dragged the slices between the small and large pies so that the sales of lizards, fish and birds are in the large pie and the hamsters and rabbits in the small pie. On the large pie each value shows its category name (hamsters, etc.) and $$ except the parent slice of the small pie which shows “Other” (excels default value) and the total $$ for the small pie (hamsters and rabbits). The client would like the name to say “Mammals” instead of “Other” which I can manually edit in that data label, but then some link gets broken to the underlying data. Now any changes to the source data will not update in the parent slice (the small pie works fine). I have tried a couple of options to resolve this… a) turn labels off, update the data, turn back on, manually overtype the “other” label b) tried to make only the category name text in the parent slice white so it wouldn’t show, then place a text box over it with the word “mammals”. None are really satisfying. Any suggestions? Is there an automation way to do this, a macro to accomplish a) above, or a way to get under the covers to change the default value of other? This would have to be workbook specific of course
<o></o>