If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hide series names for unused data from chart legend
Hi! Does anybody know a way to specify that a chart legend does not display
the name for a data series? Basically, I have 5 series plotted to allow for up to 5 modes on my chart, and all the points use the same coloured lines to demonstrate that they are all the same thing (modes). The legend wants to display the names for all of them ("Mode 1", "Mode 2", etc...) but I would prefer it to have just one entry (i.e. I would change "Mode 1" to simply "Mode", to show that any green line is a mode, regardless of how many there are - could range from 0 to 5 modes, depending on the data). Is there a way (preferably avoiding VBA) to not show all the series names? (I must have the legend visible to show the parts I do want seen). I thought of just typing a space for the series name so that it comes up blank, but I still get the 5 green line indicators, and I just need one. If anybody has any ideas I would be very grateful for the help. Neil |
#2
|
|||
|
|||
Hide series names for unused data from chart legend
Neil -
Click the legend area once to select the entire legend area. Pause. Click a single legend entry. Press Delete. - Mike www.mikemiddleton.com "Neil Goldwasser" wrote in message ... Hi! Does anybody know a way to specify that a chart legend does not display the name for a data series? Basically, I have 5 series plotted to allow for up to 5 modes on my chart, and all the points use the same coloured lines to demonstrate that they are all the same thing (modes). The legend wants to display the names for all of them ("Mode 1", "Mode 2", etc...) but I would prefer it to have just one entry (i.e. I would change "Mode 1" to simply "Mode", to show that any green line is a mode, regardless of how many there are - could range from 0 to 5 modes, depending on the data). Is there a way (preferably avoiding VBA) to not show all the series names? (I must have the legend visible to show the parts I do want seen). I thought of just typing a space for the series name so that it comes up blank, but I still get the 5 green line indicators, and I just need one. If anybody has any ideas I would be very grateful for the help. Neil |
#3
|
|||
|
|||
Hide series names for unused data from chart legend
Thanks Mike! Seems so simple now, but until you learn you can do that you'll
never know will you? Thanks for your help, it was really getting on my nerves! Neil "Mike Middleton" wrote: Neil - Click the legend area once to select the entire legend area. Pause. Click a single legend entry. Press Delete. - Mike www.mikemiddleton.com "Neil Goldwasser" wrote in message ... Hi! Does anybody know a way to specify that a chart legend does not display the name for a data series? Basically, I have 5 series plotted to allow for up to 5 modes on my chart, and all the points use the same coloured lines to demonstrate that they are all the same thing (modes). The legend wants to display the names for all of them ("Mode 1", "Mode 2", etc...) but I would prefer it to have just one entry (i.e. I would change "Mode 1" to simply "Mode", to show that any green line is a mode, regardless of how many there are - could range from 0 to 5 modes, depending on the data). Is there a way (preferably avoiding VBA) to not show all the series names? (I must have the legend visible to show the parts I do want seen). I thought of just typing a space for the series name so that it comes up blank, but I still get the 5 green line indicators, and I just need one. If anybody has any ideas I would be very grateful for the help. Neil |
#4
|
|||
|
|||
Hide series names for unused data from chart legend
Hi again Mike! Sorry, I forgot to ask something. Let's say that having
deleted it, it later becomes apparent that I need the series name back in the legend again - how would I do this please? Again, many thanks for your help, Neil "Neil Goldwasser" wrote: Thanks Mike! Seems so simple now, but until you learn you can do that you'll never know will you? Thanks for your help, it was really getting on my nerves! Neil "Mike Middleton" wrote: Neil - Click the legend area once to select the entire legend area. Pause. Click a single legend entry. Press Delete. - Mike www.mikemiddleton.com "Neil Goldwasser" wrote in message ... Hi! Does anybody know a way to specify that a chart legend does not display the name for a data series? Basically, I have 5 series plotted to allow for up to 5 modes on my chart, and all the points use the same coloured lines to demonstrate that they are all the same thing (modes). The legend wants to display the names for all of them ("Mode 1", "Mode 2", etc...) but I would prefer it to have just one entry (i.e. I would change "Mode 1" to simply "Mode", to show that any green line is a mode, regardless of how many there are - could range from 0 to 5 modes, depending on the data). Is there a way (preferably avoiding VBA) to not show all the series names? (I must have the legend visible to show the parts I do want seen). I thought of just typing a space for the series name so that it comes up blank, but I still get the 5 green line indicators, and I just need one. If anybody has any ideas I would be very grateful for the help. Neil |
#5
|
|||
|
|||
Hide series names for unused data from chart legend
Neil -
It's not so easy, but then not too hard. Delete the legend, and using the button on the chart toolbar or using Chart menu Chart Options Legend tab, add it back. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Neil Goldwasser" wrote in message ... Hi again Mike! Sorry, I forgot to ask something. Let's say that having deleted it, it later becomes apparent that I need the series name back in the legend again - how would I do this please? Again, many thanks for your help, Neil "Neil Goldwasser" wrote: Thanks Mike! Seems so simple now, but until you learn you can do that you'll never know will you? Thanks for your help, it was really getting on my nerves! Neil "Mike Middleton" wrote: Neil - Click the legend area once to select the entire legend area. Pause. Click a single legend entry. Press Delete. - Mike www.mikemiddleton.com "Neil Goldwasser" wrote in message ... Hi! Does anybody know a way to specify that a chart legend does not display the name for a data series? Basically, I have 5 series plotted to allow for up to 5 modes on my chart, and all the points use the same coloured lines to demonstrate that they are all the same thing (modes). The legend wants to display the names for all of them ("Mode 1", "Mode 2", etc...) but I would prefer it to have just one entry (i.e. I would change "Mode 1" to simply "Mode", to show that any green line is a mode, regardless of how many there are - could range from 0 to 5 modes, depending on the data). Is there a way (preferably avoiding VBA) to not show all the series names? (I must have the legend visible to show the parts I do want seen). I thought of just typing a space for the series name so that it comes up blank, but I still get the 5 green line indicators, and I just need one. If anybody has any ideas I would be very grateful for the help. Neil |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pie Chart with 3 data series? | Craig | Charts and Charting | 4 | December 19th, 2005 08:15 PM |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
Having both the date and total of series data displayed underthe data | Jon Peltier | Charts and Charting | 0 | April 14th, 2004 08:39 PM |