Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I want to create a stack column and include in the data label, the series
name and the value. Is it possible to remove the data label for zero values? Is it possible to adjust the gap at column level instead of chart level? Thanks, |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I forgot to mention that I want to remove the data label dinamically and not
manually. Thanks "Mr.LuckyMe" wrote: I want to create a stack column and include in the data label, the series name and the value. Is it possible to remove the data label for zero values? Is it possible to adjust the gap at column level instead of chart level? Thanks, |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
After you mark that you want series name and value, you than go to
froamt data labels, and than under custom add 0;-0;; This will remove zero values and only series name will remain. Best regards |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Thank you for your answer, but I want to remove dinamically the data label
(value and series name) if value=0. I know I can dellete the data labels manually, but is a very time consuming. Thanks, "Klemen25" wrote: After you mark that you want series name and value, you than go to froamt data labels, and than under custom add 0;-0;; This will remove zero values and only series name will remain. Best regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Label Max Value on Secondary Y-Axis Stacked Column | Charts and Charting in Excel | |||
Pls HLP - Label Above Column in Stacked Chart | Charts and Charting in Excel | |||
Showing Percentage Value Data Label in a 100% Stacked Column Chart | Charts and Charting in Excel | |||
Data series label in Stacked Chart | Charts and Charting in Excel | |||
Percent Data Label on 100% Stacked Column Chart | Charts and Charting in Excel |