How to visualize the two value in row into Y axis

Question & Answer
,
1

Hi,
I am new to quicksight ,I working on the some visualization , I am facing some difficult , please help me out.
I have a data like this.

FY 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030
scope 1 250 243.31 Mt-CO2 224.17 Mt-CO2 223.81 Mt-CO2 214.43 Mt-CO2 195.40 Mt-CO2 194.85 Mt-CO2 184.26 Mt-CO2 178.78 Mt-CO2 173.16 Mt-CO2 169.56 Mt-CO2
scope 2 500 468.55 Mt-CO2 466.39 Mt-CO2 459.99 Mt-CO2 443.94 Mt-CO2 426.09 Mt-CO2 394.27 Mt-CO2 360.67 Mt-CO2 337.83 Mt-CO2 317.54 Mt-CO2 313.39 Mt-CO2
scope 3 3200 3123.41 Mt-CO2 2903.40 Mt-CO2 2868.23 Mt-CO2 2655.59 Mt-CO2 2537.69 Mt-CO2 2512.92 Mt-CO2 2330.93 Mt-CO2 2139.14 Mt-CO2 1987.65 Mt-CO2 1858.28 Mt-CO2

I need like this in quicksight

Screenshot 2022-11-25 110123
Screenshot 2022-11-25 1101231249Ă—573 12.2 KB

2

Hi, @suresh1. Welcome to the QuickSight Community, and thanks so much for posting your question! :slight_smile:

Due to the US holiday, our team will review this question on Monday. In the meantime, we encourage anyone form the Community to reply.

3

You have to unpivot your data to make it look like this first:
image

Select “Stacked vertical bar chart” as your visual type, put “Year” on the x-axis, “Emission Amount” in value and “Scope” in Group/Color.

2 Likes
4

@suresh1 We hope the solution from @David_Wong worked for you. Let us know if this is resolved or if you still have questions. Thanks!

5

Thanks @Kristin and @David_Wong ,
I changed the data into the above format manually and I got the visual.
I tried to change the data with the Pivot table, but I didn’t get what I am expecting.
Would please refer me to any blog to change the data into the above format using an excel pivot table.

6

@suresh1
You need to unpivot your data, not pivot.
You can try this tutorial : Unpivot Excel Data - Excel University

2 Likes