I'm trying to make a stacked column chart that breaks a data set down by different categories, with a different stacked column for each category. For example:
-Total items
-Items by month
-Items by vendor
Each column will have the same height, because it's the same total number of items, just broken down in different ways.
So far I've got the stacked columns but I can't figure out how to label them the way I want, which is: each part of a stack has its series label and its number.
I know I can use Format Data Labels and check the boxes for Series Name and Value. The problem is that I was only able to build the columns I need by putting in zeroes, as follows:
byMonth byVendor
Jan 5 0
Feb 4 0
VendorX 0 6
VendorY 0 12
But I don't want the zeroes and series labels for the vendors to show up in the byMonth column, because they're not supposed to be there--they're just placeholders to make sure that the columns line up.
Sorry if this is confusing. How can I make the columns that I want?
-Total items
-Items by month
-Items by vendor
Each column will have the same height, because it's the same total number of items, just broken down in different ways.
So far I've got the stacked columns but I can't figure out how to label them the way I want, which is: each part of a stack has its series label and its number.
I know I can use Format Data Labels and check the boxes for Series Name and Value. The problem is that I was only able to build the columns I need by putting in zeroes, as follows:
byMonth byVendor
Jan 5 0
Feb 4 0
VendorX 0 6
VendorY 0 12
But I don't want the zeroes and series labels for the vendors to show up in the byMonth column, because they're not supposed to be there--they're just placeholders to make sure that the columns line up.
Sorry if this is confusing. How can I make the columns that I want?
