.. DO NOT EDIT.
.. THIS FILE WAS AUTOMATICALLY GENERATED BY SPHINX-GALLERY.
.. TO MAKE CHANGES, EDIT THE SOURCE PYTHON FILE:
.. "recipes/pivoting/plot_pivot_chart_all_categories.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_all_categories.py>`
        to download the full example code.

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

.. _sphx_glr_recipes_pivoting_plot_pivot_chart_all_categories.py:


Pivot Charts across All Categories
---------------------------

If plotting a pivoted chart where all categories should be included, the ``include_all_categories`` flag can be used.
When this flag is enabled, all categories within the ``pivot_column_name`` will have as series dynamically generated based on the specified ``series``.

- Each series will use a different color automatically, other formatting settings will be inherited from the ``series`` defined in the chart function
- The formatting options will be limited, so this should be used for charts where customizations per series are not necessary
- Series can still be stacked using the ``is_stacked`` flag
- Categories will be sorted on the legend in ascending order, but can be sorted on another column via the ``category_sort_column_name`` argument

.. GENERATED FROM PYTHON SOURCE LINES 14-38





.. 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="cdf66806-38d4-4a49-aaa4-c75ae12f0298" class="plotly-graph-div" style="height:610px; width:100%;"></div>            <script type="text/javascript">                window.PLOTLYENV=window.PLOTLYENV || {};                                if (document.getElementById("cdf66806-38d4-4a49-aaa4-c75ae12f0298")) {                    Plotly.newPlot(                        "cdf66806-38d4-4a49-aaa4-c75ae12f0298",                        [{"hovertemplate":"%{y:,.0f}","marker":{"color":"#0d4753"},"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":"#abd0d9"},"name":"Europe","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":"MzMzMyOz80CamZmZyUX2QM3MzMxUFPdAZmZmZubO80AAAAAAaMf0QDMzMzPjWPZAZmZmZg5S80BmZmZm1obzQAAAAAAYfPRAZmZmZoYJ9kAzMzMzC3DzQJqZmZk5OfRAAAAAAGAK9kCamZmZ8QT1QDMzMzOT3\u002fNAMzMzM9Mm9UDNzMzM5PX0QDMzMzNrZPVAZmZmZjYG9EBmZmZmvib2QA=="},"yaxis":"y","type":"bar"},{"hovertemplate":"%{y:,.0f}","marker":{"color":"#f48d5c"},"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":"#288b6f"},"name":"Asia Excl. 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":"ZmZmZnbA6UDNzMzMnKbtQDMzMzOjE\u002fBAmpmZmWnG60AAAAAAUCPrQM3MzMzcd+1AMzMzMzNl7UDNzMzM3GDsQM3MzMxsoupAzczMzIyo60AAAAAAgCzrQGZmZmaG4+tAzczMzBwH7kAzMzMzsyztQM3MzMxMgOxAZmZmZhYg7UDNzMzMvEHsQM3MzMzc1O1AzczMzAwN7kDNzMzMzLbuQA=="},"yaxis":"y","type":"bar"},{"hovertemplate":"%{y:,.0f}","marker":{"color":"#f4bb01"},"name":"Other","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":"zczMzPyC40CamZmZiVjnQM3MzMzMFO1AAAAAAGBO6ECamZmZ2W\u002fmQDMzMzPzQehAmpmZmdk650DNzMzMLOTmQDMzMzPzSOZAMzMzMxOY50DNzMzM\u002fD7nQJqZmZkpR+hAzczMzPxj6UAzMzMz00LpQGZmZmZWFOpAmpmZmXmt60BmZmZmtnjqQM3MzMzMxutAZmZmZjaJ60DNzMzMrPPsQA=="},"yaxis":"y","type":"bar"},{"hovertemplate":"%{y:,.0f}","marker":{"color":"#e9514e"},"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"},{"hovertemplate":"%{y:,.0f}","marker":{"color":"#19889F"},"name":"Yy","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":"AAAAAAAA+H8AAAAAAAD4fwAAAAAAAPh\u002fAAAAAAAA+H9VwaikTkCDP3ZPHhZqTbO\u002felORCmMLxb9DVrd6Tnqfv0GC4seYu4a\u002fj41AvK5foL+u8C4X8Z2Iv8AEbt3NU40\u002fmdNlMbH5uD+QgxJm2v51v4Ehq1s9J50\u002fVU0QdR+ApD+E9X8O8+WlvxsN4C2QoJg\u002fkZvhBnx+mD+x4emVsgyRPw=="},"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,300000,350000,400000,450000],"tickformat":",.0f","range":[0,450000]},"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",
                mode="bar",
                is_stacked=True,
                pivot_column_name="region",
                include_all_categories=True,
                # sort categories by total downloads using the ios_dl_idx column
                # in descending order (the "-" indicates descending)
                category_sort_column_name="-ios_dl_idx",
            ),
        ],
    )

    fig


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

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


.. _sphx_glr_download_recipes_pivoting_plot_pivot_chart_all_categories.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_all_categories.ipynb <plot_pivot_chart_all_categories.ipynb>`

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

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

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

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


.. only:: html

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

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