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 allow me to show more than one year as the X-AXIS?

Tagged:

Comments

  • DavidChurchman
    DavidChurchman Coach

    You need to reshape your data so the years are in a column. That would be easy in a MagicETL:

    image.png
    image.png
    image.png

    If you don't want to reshape your data, the only card I can think that would make sense "out of the box" is the pivot table card:

    image.png

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

    Please accept the answer if it solved your problem.

Categories