Data label above columns??
Hi,
I have some stacked column charts and I want the data labels to appear just above each column. Is that possible? I'm using excel 2003 version and the only options i can see for the label positions are "inside end", "center" and "inside base" - so at the moment I'm moving each data label manually and this is very time concuming! Thanks in advance for any advice you offer :) K |
Answer: Data label above columns??
Hi K,
Yes, it is possible to have the data labels appear just above each column in your stacked column chart. Here's how you can do it:
This should move all the data labels to appear just above each column in your stacked column chart. You won't have to move each label manually anymore, which should save you a lot of time. |
Data label above columns??
I'm afraid it's not an option due to the confusion it would cause. If the
label is above the stack it refers to, it could be sitting on top of another stack, thus making it unclear as to which stack it is actually referring to. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Kadence" wrote: Hi, I have some stacked column charts and I want the data labels to appear just above each column. Is that possible? I'm using excel 2003 version and the only options i can see for the label positions are "inside end", "center" and "inside base" - so at the moment I'm moving each data label manually and this is very time concuming! Thanks in advance for any advice you offer :) K |
Data label above columns??
Hi,
As Luke points out this is not an option due to the potential confusion over the association of data point with data label. Having said that it is possible to get the effect by add dummy series, plotting them as stacked line. Then using the line series to display data labels with the alignment set to Above. The dummy series would be based on the same data as the columns. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Kadence" wrote in message ... Hi, I have some stacked column charts and I want the data labels to appear just above each column. Is that possible? I'm using excel 2003 version and the only options i can see for the label positions are "inside end", "center" and "inside base" - so at the moment I'm moving each data label manually and this is very time concuming! Thanks in advance for any advice you offer :) K |
All times are GMT +1. The time now is 02:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com