Improper / additional legends while having nested axis labels for stacked column when having only 1 series

Question

Hi Microsoft tech team,

When I try to create stacked column chart with 1 series, I'm getting multiple legends based on the categories.
In the below image, I am expecting only one legend as Total instead of having 4 legends which are categories.

Data used to create this excel ->

Product	Periods	Group	Distribution
Product A	10/31/2020-11/21/2020	Total	90.0%
	10/30/2021-11/20/2021	Total	70.0%
Product B	10/31/2020-11/21/2020	Total	80.0%
	10/30/2021-11/20/2021	Total	100.0%

But if I have multiple series, I am able to see proper legends which is based only on the available series.

https://learn-attachment.microsoft.com/api/attachments/4c8ce710-1083-4f5c-8f82-e6ad6a9c9eb5?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/8ca557ca-f6de-4e8e-91e5-e3743bdbb60b?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow">

Data used to create this excel as below

Product	Periods	Geography	Percents
Product A	10/31/2020-11/21/2020	East	15.4%
	10/30/2021-11/20/2021	East	13.6%
Product B	10/31/2020-11/21/2020	East	7.5%
	10/30/2021-11/20/2021	East	15.0%
Product A	10/31/2020-11/21/2020	Central	21.8%
	10/30/2021-11/20/2021	Central	21.1%
Product B	10/31/2020-11/21/2020	Central	30.3%
	10/30/2021-11/20/2021	Central	25.6%
Product A	10/31/2020-11/21/2020	South	44.3%
	10/30/2021-11/20/2021	South	47.0%
Product B	10/31/2020-11/21/2020	South	54.7%
	10/30/2021-11/20/2021	South	29.6%
Product A	10/31/2020-11/21/2020	West	18.5%
	10/30/2021-11/20/2021	West	18.3%
Product B	10/31/2020-11/21/2020	West	7.4%
	10/30/2021-11/20/2021	West	29.8%

I am unable to attach the excels, so have added the images and the data used to create charts.

Could you please check and update on this ? Please let me know if any more info is needed.

Thanks,
Thilak Babu

Answer 1

See my sample workbook at https://www.dropbox.com/scl/fi/7gyfzczfh2w9mmdbu17zg/SampleChart.xlsx?rlkey=kps28sz3x514iie74nb6zxjsr&dl=1

Perhaps you should create the chart again from scratch...

Answer 2

Hi HansV,

Tried changing the series values as D2:D5, still the same legends

Please help!

Thanks,

Thilak

Answer 3

Try changing the Series values to

=DataSheet1!$D$2:$D$5

Answer 4

Hi @HansV,

On clicking the first chart's series,

I see the below

Series Values -> =((DataSheet1!$D$2,DataSheet1!$D$3),DataSheet1!$D$4,DataSheet1!$D$5)

On clicking the category axis label range, I see below

Axis label range -> =DataSheet1!$A$2:$B$5

Please let me know if anything else is needed

Answer 5

In the first (problem) chart:

Click Edit under Legend Entries (Series). What do you see in the Series values box?

Click Edit under Horizontal (Category Axis) Labels. What do you see in the Axis label range box?