| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Add series names to legend after the chart has been created
How do I do the above other than edit the series name in the source data
window. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Add series names to legend after the chart has been created
Hi,
You can edit the series name in the source data window. Or selecting the series and then editing the series formula in the formula bar. Or by linking to a cell reference, then you simply edit the cell. Cheers Andy Barry wrote: How do I do the above other than edit the series name in the source data window. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Add series names to legend after the chart has been created
Andy, thanks for the reply. I do not think I explained it very well.
I have a chart that is complete, and in the legend it just shows the little colour squares. Is there another way of adding the series names to the legend other than editing the source data. Barry "Andy Pope" wrote: Hi, You can edit the series name in the source data window. Or selecting the series and then editing the series formula in the formula bar. Or by linking to a cell reference, then you simply edit the cell. Cheers Andy Barry wrote: How do I do the above other than edit the series name in the source data window. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Add series names to legend after the chart has been created
Hi,
The text displayed in the legend is directly related to the series names. So if you right click the chart and pick Source Data... on the series tab you can change the contents of the Series name textbox. Cheers Andy Barry wrote: Andy, thanks for the reply. I do not think I explained it very well. I have a chart that is complete, and in the legend it just shows the little colour squares. Is there another way of adding the series names to the legend other than editing the source data. Barry "Andy Pope" wrote: Hi, You can edit the series name in the source data window. Or selecting the series and then editing the series formula in the formula bar. Or by linking to a cell reference, then you simply edit the cell. Cheers Andy Barry wrote: How do I do the above other than edit the series name in the source data window. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart series (based on datarange content) | Charts and Charting in Excel | |||
| Hide series names for unused data from chart legend | Charts and Charting in Excel | |||
| Setting Excel chart series from vb6 | Charts and Charting in Excel | |||
| Chart will not display complete series | Charts and Charting in Excel | |||
| How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
Linear Mode
