View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta[_2_] Victor Delta[_2_] is offline
external usenet poster
 
Posts: 199
Default 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