Bar Chart 2025-2028

lauramiddleton
lauramiddleton Member
in Charting

Hi, I would like to create a bar chart with X-Axis as 2025-2028, and the series as "Product Name", this is to show the growth in some products from 2025 to 2028.

My dataset has columns 2025, 2026, 2027, 2028 which have $Value. The rows are opportunity entries which contain a "Product Name".

How can I do a bar chart to show more than one year as the X-AXIS?

Tagged:

Answers

  • DavidChurchman
    DavidChurchman Coach

    With the 4 columns you describe (Product, 2025, …, 2028), I don't think there's a way to get the bar chart you described without reshaping your data first. The only card I can think of that would analyze your data as is would be the pivot table:

    image.png

    If you're willing to do a quick MagicETL to unpivot your data to a long format, then it's very easy to get what you described:

    image.png
    image.png

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • lauramiddleton
    lauramiddleton Member

    Thank you I did the Magic ETL function and worked perfectly. Thanks again

Categories