.. DO NOT EDIT.
.. THIS FILE WAS AUTOMATICALLY GENERATED BY SPHINX-GALLERY.
.. TO MAKE CHANGES, EDIT THE SOURCE PYTHON FILE:
.. "recipes/pivoting/plot_pivot_chart_stacked.py"
.. LINE NUMBERS ARE GIVEN BELOW.

.. only:: html

    .. note::
        :class: sphx-glr-download-link-note

        :ref:`Go to the end <sphx_glr_download_recipes_pivoting_plot_pivot_chart_stacked.py>`
        to download the full example code.

.. rst-class:: sphx-glr-example-title

.. _sphx_glr_recipes_pivoting_plot_pivot_chart_stacked.py:


Stacked Pivot Charts
---------------------------

Plotting charts where the input data is aggregated by a categorical column can be pivoted using ``pivot_column_name`` in the ``series`` function.

When pivoting and wanting to stack each series per point on the x-axis:

- Each category can be manually plotted as a ``series`` by specifying the ``category_name`` parameter and the ``pivot_column_name`` to use for the series
- The ``column_name`` should remain as the numerical column to plot. The data will for the series will be filtered to the specific ``category_name`` automatically
- The ``is_stacked`` parameter can control if the series are stacked vertically or kept side by side (default)
- When ``is_stacked=True``, Axis min/max are automatically calculated as the sum of all series on the specified y1 or y2 axis
- The order of the series in the legend and in the graph is based on the order of elements in ``chart_series`` parameter.

.. GENERATED FROM PYTHON SOURCE LINES 17-55





.. raw:: html

    <div class="output_subarea output_html rendered_html output_result">
    <div>            <script src="https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG"></script><script type="text/javascript">if (window.MathJax && window.MathJax.Hub && window.MathJax.Hub.Config) {window.MathJax.Hub.Config({SVG: {font: "STIX-Web"}});}</script>                <script type="text/javascript">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>
            <script charset="utf-8" src="https://cdn.plot.ly/plotly-3.0.1.min.js"></script>                <div id="09cab33e-fe15-4f4f-bfdc-cc52b8483878" class="plotly-graph-div" style="height:610px; width:100%;"></div>            <script type="text/javascript">                window.PLOTLYENV=window.PLOTLYENV || {};                                if (document.getElementById("09cab33e-fe15-4f4f-bfdc-cc52b8483878")) {                    Plotly.newPlot(                        "09cab33e-fe15-4f4f-bfdc-cc52b8483878",                        [{"hovertemplate":"%{y:,.0f}","marker":{"color":"#abd0d9"},"name":"UCAN","showlegend":true,"x":["2020-FQ1","2020-FQ2","2020-FQ3","2020-FQ4","2021-FQ1","2021-FQ2","2021-FQ3","2021-FQ4","2022-FQ1","2022-FQ2","2022-FQ3","2022-FQ4","2023-FQ1","2023-FQ2","2023-FQ3","2023-FQ4","2024-FQ1","2024-FQ2","2024-FQ3","2024-FQ4"],"y":{"dtype":"f8","bdata":"ZmZmZn6u+EDNzMzMNIn8QAAAAAD4gP5AMzMzM\u002fNt+0DNzMzMdJf5QDMzMzMTiPtAMzMzMxNm+ECamZmZ0Rf4QJqZmZmBqvhAzczMzPyn+kBmZmZm1qD4QAAAAAAww\u002fhAMzMzM\u002ftp+kBmZmZmph\u002f5QAAAAABgcPhAAAAAAOgC+UCamZmZmar3QGZmZmbW7PdAZmZmZuby9kAzMzMza9j3QA=="},"yaxis":"y","type":"bar"},{"hovertemplate":"%{y:,.0f}","marker":{"color":"#999999"},"name":"China","showlegend":true,"x":["2020-FQ1","2020-FQ2","2020-FQ3","2020-FQ4","2021-FQ1","2021-FQ2","2021-FQ3","2021-FQ4","2022-FQ1","2022-FQ2","2022-FQ3","2022-FQ4","2023-FQ1","2023-FQ2","2023-FQ3","2023-FQ4","2024-FQ1","2024-FQ2","2024-FQ3","2024-FQ4"],"y":{"dtype":"f8","bdata":"zczMzOQv9kBmZmZm9qn8QJqZmZmp8fZAzczMzCwm9EAAAAAASKbyQGZmZmY+DPVAmpmZmalJ80AAAAAAAGf1QDMzMzP7EvNAZmZmZl4O9EAAAAAAcNDyQJqZmZlRmPRAmpmZmYHC9EBmZmZm7hL0QGZmZmaGlvJAMzMzM9tr9EDNzMzMJH\u002f0QAAAAAAgOPVAZmZmZgZR9ECamZmZ4Vr0QA=="},"yaxis":"y","type":"bar"},{"hovertemplate":"%{y:,.0f}","marker":{"color":"#f48d5c"},"name":"India","showlegend":true,"x":["2020-FQ1","2020-FQ2","2020-FQ3","2020-FQ4","2021-FQ1","2021-FQ2","2021-FQ3","2021-FQ4","2022-FQ1","2022-FQ2","2022-FQ3","2022-FQ4","2023-FQ1","2023-FQ2","2023-FQ3","2023-FQ4","2024-FQ1","2024-FQ2","2024-FQ3","2024-FQ4"],"y":{"dtype":"f8","bdata":"MzMzMzMOt0AzMzMzsyq5QJqZmZmZxr5AZmZmZubjvEAAAAAAgPe6QDMzMzOzU7pAMzMzM7MSvUAzMzMzM2K6QM3MzMzMrrxAmpmZmRkQvkDNzMzMzDm\u002fQAAAAAAAab9AmpmZmVkLw0BmZmZmZm3CQJqZmZlZUMNAZmZmZiYgw0CamZmZmYzEQDMzMzMzmsVAmpmZmVnkxUAAAAAAAIHGQA=="},"yaxis":"y","type":"bar"}],                        {"template":{"data":{"histogram2dcontour":[{"type":"histogram2dcontour","colorbar":{"outlinewidth":0,"ticks":""},"colorscale":[[0.0,"#0d0887"],[0.1111111111111111,"#46039f"],[0.2222222222222222,"#7201a8"],[0.3333333333333333,"#9c179e"],[0.4444444444444444,"#bd3786"],[0.5555555555555556,"#d8576b"],[0.6666666666666666,"#ed7953"],[0.7777777777777778,"#fb9f3a"],[0.8888888888888888,"#fdca26"],[1.0,"#f0f921"]]}],"choropleth":[{"type":"choropleth","colorbar":{"outlinewidth":0,"ticks":""}}],"histogram2d":[{"type":"histogram2d","colorbar":{"outlinewidth":0,"ticks":""},"colorscale":[[0.0,"#0d0887"],[0.1111111111111111,"#46039f"],[0.2222222222222222,"#7201a8"],[0.3333333333333333,"#9c179e"],[0.4444444444444444,"#bd3786"],[0.5555555555555556,"#d8576b"],[0.6666666666666666,"#ed7953"],[0.7777777777777778,"#fb9f3a"],[0.8888888888888888,"#fdca26"],[1.0,"#f0f921"]]}],"heatmap":[{"type":"heatmap","colorbar":{"outlinewidth":0,"ticks":""},"colorscale":[[0.0,"#0d0887"],[0.1111111111111111,"#46039f"],[0.2222222222222222,"#7201a8"],[0.3333333333333333,"#9c179e"],[0.4444444444444444,"#bd3786"],[0.5555555555555556,"#d8576b"],[0.6666666666666666,"#ed7953"],[0.7777777777777778,"#fb9f3a"],[0.8888888888888888,"#fdca26"],[1.0,"#f0f921"]]}],"contourcarpet":[{"type":"contourcarpet","colorbar":{"outlinewidth":0,"ticks":""}}],"contour":[{"type":"contour","colorbar":{"outlinewidth":0,"ticks":""},"colorscale":[[0.0,"#0d0887"],[0.1111111111111111,"#46039f"],[0.2222222222222222,"#7201a8"],[0.3333333333333333,"#9c179e"],[0.4444444444444444,"#bd3786"],[0.5555555555555556,"#d8576b"],[0.6666666666666666,"#ed7953"],[0.7777777777777778,"#fb9f3a"],[0.8888888888888888,"#fdca26"],[1.0,"#f0f921"]]}],"surface":[{"type":"surface","colorbar":{"outlinewidth":0,"ticks":""},"colorscale":[[0.0,"#0d0887"],[0.1111111111111111,"#46039f"],[0.2222222222222222,"#7201a8"],[0.3333333333333333,"#9c179e"],[0.4444444444444444,"#bd3786"],[0.5555555555555556,"#d8576b"],[0.6666666666666666,"#ed7953"],[0.7777777777777778,"#fb9f3a"],[0.8888888888888888,"#fdca26"],[1.0,"#f0f921"]]}],"mesh3d":[{"type":"mesh3d","colorbar":{"outlinewidth":0,"ticks":""}}],"scatter":[{"fillpattern":{"fillmode":"overlay","size":10,"solidity":0.2},"type":"scatter"}],"parcoords":[{"type":"parcoords","line":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"scatterpolargl":[{"type":"scatterpolargl","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"bar":[{"error_x":{"color":"#2a3f5f"},"error_y":{"color":"#2a3f5f"},"marker":{"line":{"color":"#E5ECF6","width":0.5},"pattern":{"fillmode":"overlay","size":10,"solidity":0.2}},"type":"bar"}],"scattergeo":[{"type":"scattergeo","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"scatterpolar":[{"type":"scatterpolar","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"histogram":[{"marker":{"pattern":{"fillmode":"overlay","size":10,"solidity":0.2}},"type":"histogram"}],"scattergl":[{"type":"scattergl","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"scatter3d":[{"type":"scatter3d","line":{"colorbar":{"outlinewidth":0,"ticks":""}},"marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"scattermap":[{"type":"scattermap","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"scattermapbox":[{"type":"scattermapbox","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"scatterternary":[{"type":"scatterternary","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"scattercarpet":[{"type":"scattercarpet","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"carpet":[{"aaxis":{"endlinecolor":"#2a3f5f","gridcolor":"white","linecolor":"white","minorgridcolor":"white","startlinecolor":"#2a3f5f"},"baxis":{"endlinecolor":"#2a3f5f","gridcolor":"white","linecolor":"white","minorgridcolor":"white","startlinecolor":"#2a3f5f"},"type":"carpet"}],"table":[{"cells":{"fill":{"color":"#EBF0F8"},"line":{"color":"white"}},"header":{"fill":{"color":"#C8D4E3"},"line":{"color":"white"}},"type":"table"}],"barpolar":[{"marker":{"line":{"color":"#E5ECF6","width":0.5},"pattern":{"fillmode":"overlay","size":10,"solidity":0.2}},"type":"barpolar"}],"pie":[{"automargin":true,"type":"pie"}]},"layout":{"annotations":[{"align":"left","arrowcolor":"#444444","arrowhead":0,"arrowsize":0.5,"arrowwidth":1,"bgcolor":"rgba(255,255,255,0)","bordercolor":"rgba(255,255,255,0)","borderwidth":0,"font":{"color":"#444444","family":"Roboto,system-ui,sans-serif","size":16},"showarrow":false,"valign":"middle"}],"colorway":["#0d4753","#abd0d9","#f48d5c","#288b6f","#f4bb01","#e9514e","#19889F","#f8bca0","#61d1b1","#fedd71","#ef8280","#daeff2","#000000","#999999"],"font":{"color":"#444444","family":"Roboto,system-ui,sans-serif","size":16},"height":610,"hoverlabel":{"align":"left","bgcolor":"rgba(255,255,255,1)","bordercolor":"#F5F5F5","font":{"color":"#444444","family":"Roboto,system-ui,sans-serif","size":16}},"legend":{"bordercolor":"rgba(255,255,255,0)","font":{"color":"#444444","family":"Roboto,system-ui,sans-serif","size":16},"grouptitlefont":{"color":"#444444","family":"Roboto,system-ui,sans-serif","size":16},"orientation":"h","title":{"font":{"color":"#444444","family":"Roboto,system-ui,sans-serif","size":16},"side":"top","text":""},"x":0.5,"xanchor":"center","xref":"container","y":0,"yanchor":"bottom","yref":"container"},"margin":{"b":80,"l":64,"r":64,"t":64},"paper_bgcolor":"rgba(255,255,255,0)","plot_bgcolor":"rgba(255,255,255,0)","separators":".,","shapes":[{"line":{"color":"#444444","dash":"dot","width":1},"type":"line"}],"title":{"font":{"size":18}},"xaxis":{"automargin":true,"color":"#999999","gridcolor":"#f3f3f3","linecolor":"#ebebeb","showline":true,"tickfont":{"color":"#444444","family":"Roboto,system-ui,sans-serif","size":16},"title":{"font":{"color":"#444444","family":"Roboto,system-ui,sans-serif","size":16},"standoff":24}},"yaxis":{"automargin":true,"color":"#999999","gridcolor":"#f3f3f3","linecolor":"#ebebeb","showline":true,"tickfont":{"color":"#444444","family":"Roboto,system-ui,sans-serif","size":16},"title":{"font":{"color":"#444444","family":"Roboto,system-ui,sans-serif","size":16},"standoff":24},"zerolinecolor":"#bfbfbf"},"yaxis2":{"automargin":true,"color":"#999999","gridcolor":"rgba(255,255,255,0)","linecolor":"#ebebeb","overlaying":"y","showline":true,"tickfont":{"color":"#444444","family":"Roboto,system-ui,sans-serif","size":16},"title":{"font":{"color":"#444444","family":"Roboto,system-ui,sans-serif","size":16},"standoff":24},"zerolinecolor":"#bfbfbf"}}},"legend":{"title":{"text":""},"y":0},"xaxis":{"title":{"text":"Fiscal Quarter"},"tickmode":"array","tickangle":-45,"tickvals":["2020-FQ1","2020-FQ1","2020-FQ1","2020-FQ1","2020-FQ1","2020-FQ1","2020-FQ1","2020-FQ2","2020-FQ2","2020-FQ2","2020-FQ2","2020-FQ2","2020-FQ2","2020-FQ2","2020-FQ3","2020-FQ3","2020-FQ3","2020-FQ3","2020-FQ3","2020-FQ3","2020-FQ3","2020-FQ4","2020-FQ4","2020-FQ4","2020-FQ4","2020-FQ4","2020-FQ4","2020-FQ4","2021-FQ1","2021-FQ1","2021-FQ1","2021-FQ1","2021-FQ1","2021-FQ1","2021-FQ1","2021-FQ2","2021-FQ2","2021-FQ2","2021-FQ2","2021-FQ2","2021-FQ2","2021-FQ2","2021-FQ3","2021-FQ3","2021-FQ3","2021-FQ3","2021-FQ3","2021-FQ3","2021-FQ3","2021-FQ4","2021-FQ4","2021-FQ4","2021-FQ4","2021-FQ4","2021-FQ4","2021-FQ4","2022-FQ1","2022-FQ1","2022-FQ1","2022-FQ1","2022-FQ1","2022-FQ1","2022-FQ1","2022-FQ2","2022-FQ2","2022-FQ2","2022-FQ2","2022-FQ2","2022-FQ2","2022-FQ2","2022-FQ3","2022-FQ3","2022-FQ3","2022-FQ3","2022-FQ3","2022-FQ3","2022-FQ3","2022-FQ4","2022-FQ4","2022-FQ4","2022-FQ4","2022-FQ4","2022-FQ4","2022-FQ4","2023-FQ1","2023-FQ1","2023-FQ1","2023-FQ1","2023-FQ1","2023-FQ1","2023-FQ1","2023-FQ2","2023-FQ2","2023-FQ2","2023-FQ2","2023-FQ2","2023-FQ2","2023-FQ2","2023-FQ3","2023-FQ3","2023-FQ3","2023-FQ3","2023-FQ3","2023-FQ3","2023-FQ3","2023-FQ4","2023-FQ4","2023-FQ4","2023-FQ4","2023-FQ4","2023-FQ4","2023-FQ4","2024-FQ1","2024-FQ1","2024-FQ1","2024-FQ1","2024-FQ1","2024-FQ1","2024-FQ1","2024-FQ2","2024-FQ2","2024-FQ2","2024-FQ2","2024-FQ2","2024-FQ2","2024-FQ2","2024-FQ3","2024-FQ3","2024-FQ3","2024-FQ3","2024-FQ3","2024-FQ3","2024-FQ3","2024-FQ4","2024-FQ4","2024-FQ4","2024-FQ4","2024-FQ4","2024-FQ4","2024-FQ4"],"spikecolor":"#636363","spikethickness":1},"yaxis":{"title":{"text":"Downloads"},"tickmode":"array","tickvals":[0,50000,100000,150000,200000,250000],"tickformat":",.0f","range":[0,250000]},"hoverlabel":{"bgcolor":"rgba(255,255,255,1)","bordercolor":"#F5F5F5"},"barmode":"relative","hovermode":"x unified"},                        {"responsive": true}                    )                };            </script>        </div>
    </div>
    <br />
    <br />

.. code-block:: Python

    import pandas as pd

    from visualization_toolkit.helpers.plotly import chart, axis, series


    fig = chart(
        pdf,
        x_axis=axis(column_name="fiscal_qy", label="Fiscal Quarter"),
        y1_axis=axis(label="Downloads", axis_type="number", axis_min=0),
        chart_series=[
            series(
                column_name="ios_dl_idx",
                category_name="UCAN",
                color="light-blue",
                mode="bar",
                is_stacked=True,
                pivot_column_name="region",
            ),
            series(
                column_name="ios_dl_idx",
                category_name="China",
                color="light-grey",
                mode="bar",
                is_stacked=True,
                pivot_column_name="region",
            ),
            series(
                column_name="ios_dl_idx",
                category_name="India",
                color="orange",
                mode="bar",
                is_stacked=True,
                pivot_column_name="region",
            ),
        ],
    )

    fig


.. rst-class:: sphx-glr-timing

   **Total running time of the script:** (0 minutes 0.026 seconds)


.. _sphx_glr_download_recipes_pivoting_plot_pivot_chart_stacked.py:

.. only:: html

  .. container:: sphx-glr-footer sphx-glr-footer-example

    .. container:: sphx-glr-download sphx-glr-download-jupyter

      :download:`Download Jupyter notebook: plot_pivot_chart_stacked.ipynb <plot_pivot_chart_stacked.ipynb>`

    .. container:: sphx-glr-download sphx-glr-download-python

      :download:`Download Python source code: plot_pivot_chart_stacked.py <plot_pivot_chart_stacked.py>`

    .. container:: sphx-glr-download sphx-glr-download-zip

      :download:`Download zipped: plot_pivot_chart_stacked.zip <plot_pivot_chart_stacked.zip>`


.. only:: html

 .. rst-class:: sphx-glr-signature

    `Gallery generated by Sphinx-Gallery <https://sphinx-gallery.github.io>`_