Can different data series be used in the same column (Excel, Stacked Bar Chart, Multi-Category)
Good day.
My data looks like this (Please assume it is correct):
My graph (Stacked Column) from this data does not show the Multi-Category("Car Classes") information:
This is what the result should look like (Manually edited in Paint):
I have tried and failed in many different ways to get this data to show. Please help.
You will need a different data layout for the chart you desire. In order to have the A and B as series, it's easiest to put the values in their own columns. You may want to omit the line with the total to 100 ( it just doesn't add anything useful to the chart).
You may want to create a helper table for the chart layout. This can be done on a different sheet, using formulas to pull the data from the original source.
Use a data layout like below, select the data, insert a horizontal 100% bar chart and switch rows/columns.
- Convert Range to a table
- Excel VBA - Method 'Range' of object'_Worksheet' failed
- VBA for Vlookup with multiple criteria
- Filter and sort data with multiple column & row criteria and match corresponding data to it with fixed and flexible return_arrays
- How do I a gap and island analysis with a power query?
- VBA loop to extract a summary of last 30 days of emails
- Stop executing loop when first blank cell is encountered
- Filter Table, Export specific column headers and column range to CSV, and save
- Filter and sort data with multiple column & row criteria and match corresponding data to it with flexible return_arrays
- Filter and sort data with multiple column & row criteria and then match corresponding data to it with multiple flexible return_arrays
- Partial Power Query transposition so that captions remain
- Copy all cell values above a specific string to another sheet
- Excel pivot table: move value fields from row to column
- Determine if cell contains data validation
- method range of object _worksheet failed named range
- Issue while populating data in excel sheet using powershell
- In a formula, can I set a cell that changes in relation to time?
- Macro efficiency vs. Progress Bar
- How do I use logical operators with dynamic arrays?
- .NET Core / .NET 6: Creating a TLB or DLL that can be added as reference in VBA
- VBA code to prevent certain cell range from being edited but can still delete rows when needed
- How to return ordered, unique data in Excel?
- How do I connect 2 data sets in excel using dynamic functions?
- Split out numbers in a column
- SUMIF with UNIQUE criteria for multiple columns, adding all values with same name
- Excel: Print exact name found from the list for exact date
- Getting a sum of a list in excel
- How do I create array for sequence of months between 2 dates?
- Return multiple selected cells from excel into python via xlwings
- Excel Sum Complication