Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Legend and text entry
I am on Excel 2003 and need to create a simple pie chart. I am asked to put
into the legend the data, individual dollar amounts and then the total in the Legend. Is that possible and if so how can I do that without effecting my chart. Thank you. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Legend and text entry
Hi,
If you are asking how to put the values of the datapoints into the Legend - Excel does not do this by default. But you can do it by creating a custom name for each of the data points. Suppose you have the names of the data points in A1:A5 and the values you are plotting in B1:B5. Insert a column between A:B and enter the formula =A1&" - "&C1 Copy this down and then plot columns B:C. The legend will display as the name of the data point and its value. Regarding adding the Total to the Legend - You could add entry in B6 which reads ="Total: "&SUM(C1:C5) You would enter nothing in C6 and then you would plot B1:C6. -- If this helps, please click the Yes button Cheers, Shane Devenshire "naminel" wrote: I am on Excel 2003 and need to create a simple pie chart. I am asked to put into the legend the data, individual dollar amounts and then the total in the Legend. Is that possible and if so how can I do that without effecting my chart. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
plz help - regarding the stack bar legend entry as percentages | New Users to Excel | |||
how do i change chart legend entry in Excel? | Charts and Charting in Excel | |||
Legend Labels Entry | Excel Discussion (Misc queries) | |||
superscript text in legend | Charts and Charting in Excel |