ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Value fig on chart column (https://www.excelbanter.com/charts-charting-excel/106698-value-fig-chart-column.html)

chedd via OfficeKB.com

Value fig on chart column
 
Hi

Is there any way to show the value on top of a column to appear on top with a
gap as each time I run wizard to creat a column chart and select value the
number is half hidden. At present i am selcting each value and moving the fig.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200608/1


Andy Pope

Value fig on chart column
 
Hi,

I would suggest not using the 3d column chart.
If you must then try setting the data labels background font to Opaque.

Cheers
Andy

chedd via OfficeKB.com wrote:
Hi

Is there any way to show the value on top of a column to appear on top with a
gap as each time I run wizard to creat a column chart and select value the
number is half hidden. At present i am selcting each value and moving the fig.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 06:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com