Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing the Legend
Have some 'inherited' spreadsheets which are feeding into charts, I want to
re-order the legend as the order it lists the elements is a little weird i.e. the elements are IR1 (%), IR2 (%), IR3 (%) and IR4 (days) - 1, 2 and 3 are line elements and 4 is a bar. The legend always places IR4 (days) at the top when obviously I would like the legend to run in numerical order. Does anyone have any ideas?? Thanks Philip |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing the Legend
Excel puts legend entries into order of chart type and axis, in addition to
the plot order of the series. This means all columns are listed before all lines. Not much you can do about it. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Philip Drury" wrote in message ... Have some 'inherited' spreadsheets which are feeding into charts, I want to re-order the legend as the order it lists the elements is a little weird i.e. the elements are IR1 (%), IR2 (%), IR3 (%) and IR4 (days) - 1, 2 and 3 are line elements and 4 is a bar. The legend always places IR4 (days) at the top when obviously I would like the legend to run in numerical order. Does anyone have any ideas?? Thanks Philip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Legend Key Box | Charts and Charting in Excel | |||
Changing the width of the legend key | Charts and Charting in Excel | |||
Changing order of series appearing in the legend on xy scatter plo | Charts and Charting in Excel | |||
Legend | Charts and Charting in Excel | |||
legend | Charts and Charting in Excel |