Stacked Column Chart Help!

[rangers27]

Hi! Having some issues with stacked column chart.

In the attachment, in tab called "Sample Chart" I created a stacked column for just 1 faculty. However, when I try to add all faculty the stacked column run into issues (things disappear, percentages dont show etc.)

Task:
Recreate the same chart (Sample Chart tab for the 3 tabs (leukemia, kidney tumor, biology) showing all faculty on a single chart. - stacked column for the (3 RVU types) for each Faculty for 2022 and 2021 (1 chart per tab showing all faculty in that tab)
The values under 2021 and 2022 should be shown as a percentage.

Can anyone please help?

[MrShorty]

I'm not sure exactly what you are trying to do. If I were to guess, you want some kind of clustered and stacked 100% column chart. If I have guessed correctly, this tutorial should help you: https://peltiertech.com/clustered-st...mn-bar-charts/ Note that most of the work of creating the chart is arranging the data in the spreadsheet. The chart is a basic 100% stacked column chart.

[avk]

Refer Attach file. Look like this required.
In this case create summary of faculty & calculate percentage between two years.

[josephteh]

First, convert your data as an Excel Table, then using Power Query to convert the Table to show in 5 columns: "Faculty", "Year", "Inpatient E&M", "Outpatient E&M" and "Procedure & Other".

Finally, plot the chart, selecting the "Faculty" and "Year" as the horizontal axis labels and the RVU Type as the Series entries.

RVU Type by Faculty by Year.png