Comparing two pivot tables and putting data into 1x bar chart

[Kaz28EN]

Hi I have 2x seperate pivot tables for utilitie data from 2024-2025 and data from 2025-2026, i need to compare the data from the 2x seperate pivot tables and combine them to get a bar chart so we can compare the utilitie data 

Any ideas if this can be done?

Thanks in advance

[v-nmadadi-msft]

Hi @Kaz28EN ,

May I check if this issue has been resolved? If not, Please feel free to share sample data if you have any further questions.

Thank you

[v-dineshya · Accepted solution]

Hi @Kaz28EN ,

Thank you for reaching out to the Microsoft Community Forum.

As mentioned by @ryan_mayu , Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.

Regards,

Dinesh

[v-dineshya]

Hi @Kaz28EN ,

We haven’t heard from you on the last response and was just checking back to see , Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.

Regards,

Dinesh

[ryan_mayu]

could you pls proivde some sample data and expected output?

[FarhanJeelani]

Hi @Kaz28EN ,

Yes, you can compare two separate pivot tables and create a single 1x bar chart to visualize the comparison. Here are a few approaches, depending on your tools (Excel, Google Sheets, or a BI tool). I’ll outline simple, practical methods and give you step-by-step steps.

Use a single consolidated data table (recommended for most charts)

Goal: Build one data table that combines 2024-2025 and 2025-2026 data, then chart from that.
Steps (in Excel/Sheets):

Create a new summary table.
Columns: Category (Utility), Year, Value (or 2024-25, 2025-26 as separate columns).
Populate the summary table by pulling values from your two pivot tables.
If your pivot tables have the same layout (same categories), you can copy-paste values.
Alternatively, use GETPIVOTDATA (Excel) or an equivalent function to pull values by category and year.

Structure (two common layouts):
Long format:
A: Utility category (e.g., Electricity, Water, Gas)
B: Year (2024-2025 or 2025-2026)
C: Value
Wider format (two value columns):
A: Utility category
B: 2024-2025
C: 2025-2026
Create the 1x bar chart.
If you used long format: create a clustered bar chart (one bar per year per category) or a 100% stacked bar if you want share comparison.
If you used wide format: select the two value columns and insert a clustered bar chart (two bars per category: 2024-2025 vs 2025-2026) and customize colors.
Optional: add a legend, data labels, and axis titles for clarity.

Please mark this post as solution if it helps you. Appreciate Kudos.