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

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.

could you pls proivde some sample data and expected output?

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