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
|
|||
|
|||
Need help positioning data labels
I have a clustered column chart and I selected the “Center” option for data
labels. When I change the chart type to clustered cylinder, my data labels move to the top of the cylinders, and there is no longer a “Center” option for data labels. I would like my data labels centered (i.e., shown in the middle of each cylinder) without having to move them manually. Is there a work-around? I am using Excel 2007. I would greatly appreciate any help. Thanks, Bob |
#2
|
|||
|
|||
Need help positioning data labels
Oh, the joys of 3d charts...
Since the label is positioned in the center of the cylinder front-to-back, XL won't let you put the label in middle top-to-bottom (as it would be inside the image). However, the bigger question is, why are you wanting to take up extra space in your chart and create image distortion with a 3d graph? A simple 2d column chart would show the same info, and be much clearer. At the very least, if you decide to keep the 3d chart, at least make sure the gap depth is set to 0. Otherwise it's almost impossible to see where the top of the cylinder lines up with on the y-axis. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Bob" wrote: I have a clustered column chart and I selected the “Center” option for data labels. When I change the chart type to clustered cylinder, my data labels move to the top of the cylinders, and there is no longer a “Center” option for data labels. I would like my data labels centered (i.e., shown in the middle of each cylinder) without having to move them manually. Is there a work-around? I am using Excel 2007. I would greatly appreciate any help. Thanks, Bob |
#3
|
|||
|
|||
Need help positioning data labels
Hi Luke,
Per your response, it appears that what I am attempting to do cannot be done. I guess it is a matter of personal taste, but I find the 2-D charts boring when compared to the 3-D charts. I realize it can be more difficult for someone to see where the top of the cylinder lines up on the y-axis, but to compensate, I already have set the gap depth to zero. Anyway, thanks for your quick response. I really appreciate it. Regards, Bob "Luke M" wrote: Oh, the joys of 3d charts... Since the label is positioned in the center of the cylinder front-to-back, XL won't let you put the label in middle top-to-bottom (as it would be inside the image). However, the bigger question is, why are you wanting to take up extra space in your chart and create image distortion with a 3d graph? A simple 2d column chart would show the same info, and be much clearer. At the very least, if you decide to keep the 3d chart, at least make sure the gap depth is set to 0. Otherwise it's almost impossible to see where the top of the cylinder lines up with on the y-axis. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Bob" wrote: I have a clustered column chart and I selected the “Center” option for data labels. When I change the chart type to clustered cylinder, my data labels move to the top of the cylinders, and there is no longer a “Center” option for data labels. I would like my data labels centered (i.e., shown in the middle of each cylinder) without having to move them manually. Is there a work-around? I am using Excel 2007. I would greatly appreciate any help. Thanks, Bob |
#4
|
|||
|
|||
Need help positioning data labels
Hi,
The choice of 3d chart will preclude you from using the secondary axis option, which would be a work around towards your other problem. Cheers Andy On 12/02/2010 14:13, Bob wrote: Hi Luke, Per your response, it appears that what I am attempting to do cannot be done. I guess it is a matter of personal taste, but I find the 2-D charts boring when compared to the 3-D charts. I realize it can be more difficult for someone to see where the top of the cylinder lines up on the y-axis, but to compensate, I already have set the gap depth to zero. Anyway, thanks for your quick response. I really appreciate it. Regards, Bob "Luke M" wrote: Oh, the joys of 3d charts... Since the label is positioned in the center of the cylinder front-to-back, XL won't let you put the label in middle top-to-bottom (as it would be inside the image). However, the bigger question is, why are you wanting to take up extra space in your chart and create image distortion with a 3d graph? A simple 2d column chart would show the same info, and be much clearer. At the very least, if you decide to keep the 3d chart, at least make sure the gap depth is set to 0. Otherwise it's almost impossible to see where the top of the cylinder lines up with on the y-axis. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Bob" wrote: I have a clustered column chart and I selected the “Center” option for data labels. When I change the chart type to clustered cylinder, my data labels move to the top of the cylinders, and there is no longer a “Center” option for data labels. I would like my data labels centered (i.e., shown in the middle of each cylinder) without having to move them manually. Is there a work-around? I am using Excel 2007. I would greatly appreciate any help. Thanks, Bob -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|