Since upgrade, value labels on chart not working properly

BiggusDoggus

Board Regular
Joined
Jul 7, 2014
Messages
91
Office Version
  1. 365
Platform
  1. Windows
Hi all

I had a combo clustered/stacked chart that up until mid last week was working fine as far as value labels were concerned. Since then I have had the Office upgrade, and the Labels have busted.

Specifically, the chart is filtered to only show 3 months of the year (May/June/July). The Value labels do not show - the box is ticked, nothing there.
However - if I unfilter Dec & Nov, the labels reappear for May. Unfilter Oct, Jun appears. Sep, Jul appears.

quSmeqi.png


OZpN9aH.png


What the heck??
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Hi again

It's not just happening with stacked column charts - in a completely different workbook, with a clustered chart, exactly the same thing is happening.

dC2YMVa.png


HXwzcQN.png


The only variation is, no matter what I select/unfilter, I can't get the labels for Nov-Dec to appear.

Has anybody got any ideas please? Is it happening to anyone else?
 
Upvote 0
In addition, if I filter out Jan, the label disappears from Oct. Filter out Feb, the filter goes from Sep, and so on.....
 
Upvote 0

Forum statistics

Threads
1,223,894
Messages
6,175,252
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top