Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a bar chart with multiple bars and I would like to show only the values on data point when zoomed in so that they won't overlap.
Hi,
In your chart, first uncheck the 'Values on Data Points' option. (Right Click on the Chart, Properties / "Expressions" Tab).
Then, in the "Expressions" Tab, click on the "+" symbol near the expressions you want to hide labels.
All you need to do is to define a expression of the "Show Value" attribute expression.
When the value of this expression is equal to Zero, no value labels are displayed on the chart, in other cases, values are displayed.
For example if you enter the following expressions :
=(GetSelectedCount([Date])<5)
You will only display value when less than 4 dates are selected
Hope this helps.
Trigger the below macro in
Sub FitZoomToWindow
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.FItZoomToWindow
End Sub
Settings -> Document Properties -> Triggers -> On open -> Add Action -> Add -> External -> Run Macro -> Give Macro Name (FitZoomToWindow)
Before that paste the above macro code in the Edit Module window (Ctrl + M).
For some other sample macros check the link below
HTH
Vikas