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.
Bookmarks