Column chart with two different data ranges

[jayjay2020]

Hello!

I wonder if it's possible to create one comparison chart with two very different data ranges.

For example quantities of sold products compared to the net sales value.
These numbers go in very different ranges (for example quantity can be 2, whereas net sales value might be 500), so a regular comparison chart doesn't work, since the value 2 is compared to 500 which doesn't make sense here.

Not sure if it's possible somehow to have the max value of the chart on one side set as max value of net sales, and on the other side as max value of quantities..?

What I would need, is to compare all the quantities of different products to each other, and all the net sales to each other, but also to have the quantity and net sale of each product in a graph. Attaching the example file. Basically, I would like to have both of the different charts (blue = quantities, orange = net sales) to visually look similar within the same graph.

[Mrrrr]

It is possible by setting a secondary axis for 1 of the ranges, by going to Chart Design - Change Chart Type - Combo - then adding a check in the Secondary Axis column for 1 of the 2 Series.

See attached for an example.

[jayjay2020]

amazing, thank you Mrrrr

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.