Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Bar of Pie Chart: Series1 Label & Value Issue
I have created a Bar of Pie chart and everything works great. I even have
named ranges on my data so that the bar portion automatically updates when the data changes. However the Series1 Label on the pie itself does not change to reflect the new total so that it is the sum of all the values in the right column below. Does that make sense? I have one series and my data looks like this: Contracts 100 Name1 100 Name2 150 Name3 200 Name4 75 Name5 50 Name6 25 The pie portion has Contracts & Other as labels with the totals of 100 and 617 respectively (the 617 total is from the last time I changed the chart). The Other label should be 600. The Values named range is all the numbers in the right column and the Labels named range is all the items on the left. I would also like to have the label that shows "Other" to be named "Programs" but do not know how to do that when the chart is refreshed each time. Thank you for any help that you can provide! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Bar of Pie Chart: Series1 Label & Value Issue
Hi,
Hi, turn on Values and Categories for data labels (and percent if you want). Single click any data lable. then single click the "Other" data lable. Drag through the word Other and replace it with the title you want. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Walter" wrote: I have created a Bar of Pie chart and everything works great. I even have named ranges on my data so that the bar portion automatically updates when the data changes. However the Series1 Label on the pie itself does not change to reflect the new total so that it is the sum of all the values in the right column below. Does that make sense? I have one series and my data looks like this: Contracts 100 Name1 100 Name2 150 Name3 200 Name4 75 Name5 50 Name6 25 The pie portion has Contracts & Other as labels with the totals of 100 and 617 respectively (the 617 total is from the last time I changed the chart). The Other label should be 600. The Values named range is all the numbers in the right column and the Labels named range is all the items on the left. I would also like to have the label that shows "Other" to be named "Programs" but do not know how to do that when the chart is refreshed each time. Thank you for any help that you can provide! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic chart pasted to a new workbook in report can't be dynamic | Charts and Charting in Excel | |||
Dynamic chart - series label problem | Charts and Charting in Excel | |||
XL Axis label formatting issue | Charts and Charting in Excel | |||
Dynamic Ranges: Speed Issue | Excel Worksheet Functions | |||
Label an average line in a dynamic chart | Charts and Charting in Excel |