Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Series order in a chart legend.
I want to reorder the series in a chart. The posting talk about editing a
command line. But I do not see a command line and Excel help does not know what a command line is. When I double clik on the series (as suggested in the postings), the menu does not offer a tab for reordering the entries. It only offer changing the text size or patterns in the legend. So why is this so difficult to accomplish? |
#2
|
|||
|
|||
What type of graph are you plotting? Select the axis of the data that you want to change- by clicking on the axis (two squares should appear on either side of the axis)- Not the data series... either double click or right click and select 'Format Axis'. This brings up a pop-up form, go to the scale tab. On the bottom of the form there are three check boxes, select the middle box- categories in reverse order. That should work- if not please let me know- If you'd like to use code to do it- see below, the line in blue is the relevant one in the with block. cheers, pim ActiveSheet.ChartObjects(1).Activate With ActiveChart.Axes(xlCategory) .CrossesAt = 1 .TickLabelSpacing = 1 .TickMarkSpacing = 1 .AxisBetweenCategories = True .ReversePlotOrder = True .MajorTickMark = xlOutside .MinorTickMark = xlNone .TickLabelPosition = xlLow End With -- Pim ------------------------------------------------------------------------ Pim's Profile: http://www.excelforum.com/member.php...o&userid=27565 View this thread: http://www.excelforum.com/showthread...hreadid=470926 |
#3
|
|||
|
|||
It sounds like maybe you are double clicking the series in the legend. You
want to double click the series (the bar/column/data point) in the plot area instead. From there there should be a tab called "Series Order" where you can move them up and down. -- Thanks, Christopher This posting is provided "AS IS" with no warranties, and confers no rights. "Phil" wrote: I want to reorder the series in a chart. The posting talk about editing a command line. But I do not see a command line and Excel help does not know what a command line is. When I double clik on the series (as suggested in the postings), the menu does not offer a tab for reordering the entries. It only offer changing the text size or patterns in the legend. So why is this so difficult to accomplish? |
#4
|
|||
|
|||
Note that Excel only allows you to reorder similar series. For example, if you have
two column series and two line series in the chart, you can only reorder the line series amongst themselves, and likewise the column series. You cannot move the line series legend entries before the column series entries. Similarly, within a group, the secondary axis series are always listed after the primary axis series. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Christopher Scott [MSFT] wrote: It sounds like maybe you are double clicking the series in the legend. You want to double click the series (the bar/column/data point) in the plot area instead. From there there should be a tab called "Series Order" where you can move them up and down. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Legend Entries | Excel Discussion (Misc queries) | |||
Order of items in legend | Charts and Charting in Excel | |||
How to hide a dummy series in a chart legend? | New Users to Excel | |||
How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) |