Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Chart Question
I have a chart which plots several lines of data. However, for several
reasons, I would like to omit some of the names and lines from the legend box. I have tried deleting the names via the 'Source Data...' dialogue box but this just results in the the names being replaced by 'Series 6' etc. Is there any way to do this please? Thanks, V |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Chart Question
Victor Delta wrote:
I have a chart which plots several lines of data. However, for several reasons, I would like to omit some of the names and lines from the legend box. I have tried deleting the names via the 'Source Data...' dialogue box but this just results in the the names being replaced by 'Series 6' etc. Is there any way to do this please? Thanks, V First click anywhere in the legend (to select the entire legend), then click one series item inside the legend (you should see the selection change to only that item), then tap delete. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Chart Question
"smartin" wrote in message
... Victor Delta wrote: I have a chart which plots several lines of data. However, for several reasons, I would like to omit some of the names and lines from the legend box. I have tried deleting the names via the 'Source Data...' dialogue box but this just results in the the names being replaced by 'Series 6' etc. Is there any way to do this please? Thanks, V First click anywhere in the legend (to select the entire legend), then click one series item inside the legend (you should see the selection change to only that item), then tap delete. Well I never! Brilliant! Never knew it was there! Many thanks, V |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Chart Question | Excel Discussion (Misc queries) | |||
Excel Chart question using two y axes | Excel Discussion (Misc queries) | |||
Excel Chart Question | Excel Discussion (Misc queries) | |||
Microsoft Excel CHART question | Excel Worksheet Functions | |||
Excel chart question | Charts and Charting in Excel |