Get Free Trial

Comparing three years of cost data in the Pivot Table with a stacked bar chart

Answered
Georgie Kourkounakis asked on June 28, 2021

Hello, 
Hope your day is going well! 
One of the Charting options I see is a stacked column chart.  I’m trying to get data for three years to stack in the stacked column chart, but I can only get one year of data in a bar at a time.
How do I get three years of data to display in one column (stacked column)? 
Thank you!
Georgie 

1 answer

Public
Vera Didenko Vera Didenko Flexmonster June 29, 2021

Hello, Georgie,
 
Thank you for your writing to us
 
We have prepared a JSFiddle for illustration: https://jsfiddle.net/flexmonster/yg2rn0fb/.
In the example, each stacked column displays three years of data.
 
Please let us know if this helps.
 
Kind regards,
Vera

Please login or Register to Submit Answer