Need some help please! I'm trying to create a stacked chart where each quarter's data for each business unit (AAA - EEE) is grouped together and I'm having a hard time figuring out if it's even possible to do. I've attached a spreadsheet with the sample data (two table layouts of it), the chart of what is easily accomplished and a mock up picture of what I'm looking for. Any thoughts?
Thank you!
You need yet another data layout. Each business AAA BBB etc in 3 rows - each for one quarter. And 4 columns for A B C D
(if you want spacers between businesses as in sample picture - each business in 5 rows: empty, 3 quarters, empty)
Then as labels for x axis 2 columns.
see attachment.
Small but important tip - cell B36 (yellow fill) is not empty - there is single space. Try to delete and see what changed in the horizontal axis
Best Regards,
Kaper
Thank you Kaper, that is exactly it! I appreciate the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks