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
|
|||
|
|||
How do I change the order of the series presented in a chart's Leg
My chart contains Lines for planning data and Bars for the Actual data. In
the Legend I want to the see the two side by side; however, it appears that Excel wants to put all the Bars first and then the Lines. (Excel 2007) |
#2
|
|||
|
|||
How do I change the order of the series presented in a chart'sLeg
Excel only lets you reorder series of the same type. You have to keep
bars and lines separate. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Chartman wrote: My chart contains Lines for planning data and Bars for the Actual data. In the Legend I want to the see the two side by side; however, it appears that Excel wants to put all the Bars first and then the Lines. (Excel 2007) |
#3
|
|||
|
|||
How do I change the order of the series presented in a chart's Leg
Hi,
You can create a legend in the spreadheet, setting it up any way you want and then you can use the Camera tool to copy the range and paste it to the chart, removing the buil-in legend. This is not a wonderful solution but it does work. I have samples of just that technique. my name at sbcglobal.net no spaces. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Chartman" wrote: My chart contains Lines for planning data and Bars for the Actual data. In the Legend I want to the see the two side by side; however, it appears that Excel wants to put all the Bars first and then the Lines. (Excel 2007) |
Thread Tools | |
Display Modes | |
|
|