Hi,
I have a raw data to create a chart to show a comparison each month for year 2019 and 2020 with multiple products.
I have chosen a column chart (clustered chart or stacked chart).
My problem is the product quantity is in proportion, the average of the product quantity is between 1 - 900 but one product has 13000 quantity.
As a result, the chart does not look in proportion.
I tried to work around the chart, adjusted the axis' format (being the quantity) from 0 - 13000 to only show from 0 - 1000 and also change the unit format.
Then changed the chart to show the quantity on each bar but the ones above 1000 won't show the quantity because of the unit format that i adjusted.
Please see attached for reference.
can anyone help me how to visualize the best. thank you.
Bookmarks