Hello! I need your help with a pie chart. I have created a pie chart using the following information below:
The pie chart uses the YTD 2007 Data (Column B) and the Supply Labels (Column A) to create the chart. I've included the data labels (name, YTD 2007 Sales and the % that each category represents of the total pie).
Where I'm having difficulty is adding in the values from the Growth % column (Column E) onto the graph such that I do not have to create text boxes with linked text each time I update the data. My hope is that there is a way to have these growth %'s update and move with graph dynamically. In particular, it would be great if these values were on the inside of the pie piece rather than on the outside with the data labels.
Any and all help is much appreciated. I also have this in an excel worksheet that I can send. I'm not sure how to post it in here for your review, but if someone knows how to post, please let me know!
Thanks!
Andrea
The pie chart uses the YTD 2007 Data (Column B) and the Supply Labels (Column A) to create the chart. I've included the data labels (name, YTD 2007 Sales and the % that each category represents of the total pie).
Where I'm having difficulty is adding in the values from the Growth % column (Column E) onto the graph such that I do not have to create text boxes with linked text each time I update the data. My hope is that there is a way to have these growth %'s update and move with graph dynamically. In particular, it would be great if these values were on the inside of the pie piece rather than on the outside with the data labels.
Any and all help is much appreciated. I also have this in an excel worksheet that I can send. I'm not sure how to post it in here for your review, but if someone knows how to post, please let me know!
Thanks!
Andrea
