Problems with Stacked bar chart

šŸ“Š Plotly Python
1

Hello,
I am having a problem showing a stacked bar chart, even though I am following the examples in the Plotly documentation :frowning:

Here is the graph I am seeing:

image
image1468Ɨ447 15.6 KB

And the code that generates it:
px.bar(overall_monthly_dividends, x=ā€œQuarterā€, y=ā€œDividends Revenueā€,color=ā€˜Sourceā€™,barmode=ā€˜stackā€™)

What am I doing wrong?
Thanks!

2

Hey @mkozak88 Welcome to the community.

Itā€™s pretty hard to tell without the data. Did you compare the DataFrame structure of your data with the examples in the documentation?

3

Hey,
The data is pretty standard I think, Here is a snippet of it:

image
image472Ɨ631 11.6 KB

4

OK, you have to restructure your df. Based on the canā€™t see based on stacking could be done. quarter is new record. Please take a look on how the df of the stacked barchart examples is structured.

5

Iā€™m sorry, I donā€™t understand.
What do you mean by restructure? what is wrong with my current structure?
I revisited the data from the examples, such as:
image

I donā€™tknow what is the difference.

6

You need to split your quarter column into a real quarter column q1-q4 and a year column.

7

Hi @mkozak88, are you able to share more of the data? At the minute, none of the ā€œPredictionā€ data is showing, so itā€™s tricky to know what the output ought to look like.