Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Erase Key in Legend
Hi everybody
I have a Pie Chart, with a legend. Is there a easy way, to erase the legend keys in the legend? If I change the color, the color of the linked slice changes too! I'm glad for any suggestion. Cheers Carlo |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Erase Key in Legend
You can delete the entire legend. Not what you want?
Of course changing the key changes the chart - that is the purpose of a legend key. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Carlo" wrote in message ... Hi everybody I have a Pie Chart, with a legend. Is there a easy way, to erase the legend keys in the legend? If I change the color, the color of the linked slice changes too! I'm glad for any suggestion. Cheers Carlo |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Erase Key in Legend
Hi Bernard
Thanks for your answer. But unfortunately in this particular case, we want to achieve, that every slice of the pie has his label (a,b,c...) and the legend reads: "A 10,00% Europe" "B 20,00% Asia" etc. If we do it like that we have 2 identifiers for each slice, which isn't necessary. So we want to get rid of the Key. Hope I made myself clearer! If not, don't hesitate to ask, i appreciate every response! Greetings Carlo "Bernard Liengme" wrote: You can delete the entire legend. Not what you want? Of course changing the key changes the chart - that is the purpose of a legend key. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Carlo" wrote in message ... Hi everybody I have a Pie Chart, with a legend. Is there a easy way, to erase the legend keys in the legend? If I change the color, the color of the linked slice changes too! I'm glad for any suggestion. Cheers Carlo |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Erase Key in Legend
I have a solution, it works and only looks complex.
If you email me privately I will send you a file. Here goes: I will assume the labels (A,B,C..) are in A2:A10 and the values in B2:B10 In D2:D10 type the areas (Europe, Asia, .....) In E2 enter this formula =A2&" "&TEXT(B2,"0.00%")&" "&" "&D2&" "&CHAR(13) and copy down to E10 You can vary the number of decimals to suit purpose On chart, add Title axis (Chart;Option:Title) and type any letter you like i.e Z Select the Z in chart title, type an equals sign (=) IN THE FORMULA BAR not on chart and then select E2:E10 Drag the title to wherever you need the new 'legend" If needed check the chart and type a new title and drag this into position best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Carlo" wrote in message ... Hi Bernard Thanks for your answer. But unfortunately in this particular case, we want to achieve, that every slice of the pie has his label (a,b,c...) and the legend reads: "A 10,00% Europe" "B 20,00% Asia" etc. If we do it like that we have 2 identifiers for each slice, which isn't necessary. So we want to get rid of the Key. Hope I made myself clearer! If not, don't hesitate to ask, i appreciate every response! Greetings Carlo "Bernard Liengme" wrote: You can delete the entire legend. Not what you want? Of course changing the key changes the chart - that is the purpose of a legend key. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Carlo" wrote in message ... Hi everybody I have a Pie Chart, with a legend. Is there a easy way, to erase the legend keys in the legend? If I change the color, the color of the linked slice changes too! I'm glad for any suggestion. Cheers Carlo |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Erase Key in Legend
Hi Bernard
Thanks a lot for this "workaround" it works perfect. Greetings Carlo "Bernard Liengme" wrote: I have a solution, it works and only looks complex. If you email me privately I will send you a file. Here goes: I will assume the labels (A,B,C..) are in A2:A10 and the values in B2:B10 In D2:D10 type the areas (Europe, Asia, .....) In E2 enter this formula =A2&" "&TEXT(B2,"0.00%")&" "&" "&D2&" "&CHAR(13) and copy down to E10 You can vary the number of decimals to suit purpose On chart, add Title axis (Chart;Option:Title) and type any letter you like i.e Z Select the Z in chart title, type an equals sign (=) IN THE FORMULA BAR not on chart and then select E2:E10 Drag the title to wherever you need the new 'legend" If needed check the chart and type a new title and drag this into position best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Erase Key in Legend
Glad it helped
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Carlo" wrote in message ... Hi Bernard Thanks a lot for this "workaround" it works perfect. Greetings Carlo "Bernard Liengme" wrote: I have a solution, it works and only looks complex. If you email me privately I will send you a file. Here goes: I will assume the labels (A,B,C..) are in A2:A10 and the values in B2:B10 In D2:D10 type the areas (Europe, Asia, .....) In E2 enter this formula =A2&" "&TEXT(B2,"0.00%")&" "&" "&D2&" "&CHAR(13) and copy down to E10 You can vary the number of decimals to suit purpose On chart, add Title axis (Chart;Option:Title) and type any letter you like i.e Z Select the Z in chart title, type an equals sign (=) IN THE FORMULA BAR not on chart and then select E2:E10 Drag the title to wherever you need the new 'legend" If needed check the chart and type a new title and drag this into position best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Legend | Charts and Charting in Excel | |||
Legend disappears from chart. | Charts and Charting in Excel | |||
Chart Legend Entries | Excel Discussion (Misc queries) | |||
XY Scatter Legend when Edit Individual Markers | Charts and Charting in Excel | |||
Subscript in legend? | Charts and Charting in Excel |