Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series order in Legend
Hello there,
It seems the legend is showing the the series by the order at which they have been created. Is there a way to change the "showing-order" of series -moving them up or down-? Thanks, Jen |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series order in Legend
In the chart, right-click on a series, Format Data Series/ Series Order tab.
-- David Biddulph "Jen" wrote in message ... Hello there, It seems the legend is showing the the series by the order at which they have been created. Is there a way to change the "showing-order" of series -moving them up or down-? Thanks, Jen |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series order in Legend
Hi David,
Thanks! ( I tried it on a very simple fresh chart and there it works as you told..) I tried to get to work on my chart (there are about 20 series in my bubble chart) and it does move some series but ...others I cannot move for some obscure reason! Do you have any ideas why? And how to resolve this? Thanks, Jen "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... In the chart, right-click on a series, Format Data Series/ Series Order tab. -- David Biddulph "Jen" wrote in message ... Hello there, It seems the legend is showing the the series by the order at which they have been created. Is there a way to change the "showing-order" of series -moving them up or down-? Thanks, Jen |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series order in Legend
Are all the series on the same axis?
Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Jen" wrote in message ... Hi David, Thanks! ( I tried it on a very simple fresh chart and there it works as you told..) I tried to get to work on my chart (there are about 20 series in my bubble chart) and it does move some series but ...others I cannot move for some obscure reason! Do you have any ideas why? And how to resolve this? Thanks, Jen "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... In the chart, right-click on a series, Format Data Series/ Series Order tab. -- David Biddulph "Jen" wrote in message ... Hello there, It seems the legend is showing the the series by the order at which they have been created. Is there a way to change the "showing-order" of series -moving them up or down-? Thanks, Jen |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series order in Legend
Hi Andy,
Yes they are ..it are about 20 series with an x-, a y -and a size- value (as it is a bubble chart). There is no "magic" on the chart, ie. no VBA manipulation or so. Rather straightforward actually. Jen PS: I helped my way out just by re-creating the series in the right order, but still ...puzzling. "Andy Pope" wrote in message ... Are all the series on the same axis? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Jen" wrote in message ... Hi David, Thanks! ( I tried it on a very simple fresh chart and there it works as you told..) I tried to get to work on my chart (there are about 20 series in my bubble chart) and it does move some series but ...others I cannot move for some obscure reason! Do you have any ideas why? And how to resolve this? Thanks, Jen "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... In the chart, right-click on a series, Format Data Series/ Series Order tab. -- David Biddulph "Jen" wrote in message ... Hello there, It seems the legend is showing the the series by the order at which they have been created. Is there a way to change the "showing-order" of series -moving them up or down-? Thanks, Jen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing order of series appearing in the legend on xy scatter plo | Charts and Charting in Excel | |||
Legend Modification - out of order | Charts and Charting in Excel | |||
Series order conflicts with line order | Charts and Charting in Excel | |||
Series order in a chart legend. | Charts and Charting in Excel | |||
Order of items in legend | Charts and Charting in Excel |