#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 199
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 915
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Chart Question Hardeep Kanwar Excel Discussion (Misc queries) 2 April 8th 09 05:29 PM
Excel Chart question using two y axes [email protected] Excel Discussion (Misc queries) 2 July 30th 07 07:01 PM
Excel Chart Question Judy Felfe Excel Discussion (Misc queries) 0 May 25th 06 04:41 PM
Microsoft Excel CHART question Wanda Excel Worksheet Functions 0 April 21st 05 06:23 PM
Excel chart question yadernye Charts and Charting in Excel 2 February 1st 05 09:07 PM


All times are GMT +1. The time now is 08:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"