1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is there any possible way to show 3 metrics in a stacked 100% pivot chart?

Our take

Good morning, everyone. I’m reaching out for assistance with a challenge posed by my professor. He has tasked me with displaying three metrics—Sales $, Units %, and SKU Count—in a 100% Stacked Bar chart for each period. Each segment needs to clearly illustrate these metrics, aligned beneath each other. I’m curious if Excel can effectively present all three metrics within the same stacked chart. Any insights or guidance on how to achieve this would be greatly appreciated. Thank you!

https://preview.redd.it/psa0afrlhywg1.png?width=2048&format=png&auto=webp&s=d56baf90562b53d863ce10549d1b649ed1c763c9

Good morning, everyone.

Seeking help, I have been challenged by my professor to show 3 metrics in a 100% Stacked Bar for each period. He wants to see SALES $, UNITS %, SKU COUNT for every segment; each segment is divided by the above, aligned, under. Is there any way excel can show the 3 metrics per segment or not?

submitted by /u/Connect_Fig8050
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#rows.com#metrics#100% Stacked Bar#segment#SALES $#UNITS %#SKU COUNT#excel#pivot chart#visualization#period#performance measurement#data segmentation#alignment#data analysis