Area Chart 2025-2028

lauramiddleton
lauramiddleton Member
in Charting

Hi I am trying to do an area chart which I have on an excel.

I have $ values per year, and the series would be "Field Life Cycle" so for example, E&A, Development, Production.

When I look at doing an area chart or even a bar chart, how can I add in more than one year? It only lets me add in 'Sum of 2025' for example, but I would like along the X-Axis to show 2025-2028 and a stacked area chart % to show Development is % of Total and how it is growing into 2028.

Tagged:

Answers

  • 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

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

    Please accept the answer if it solved your problem.

Categories