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

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.

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