I have a chart where the y-axis represents the revenue percentage and the x-axis represents the product type. I would like to visualize the same chart, but with the quantity of products sold on the y-axis instead. However, I would like to have this visualization without needing another chart, but by applying only a select option on the graph, where upon selection, I can change the visualization of this graph (revenue vs. quantity of products sold).
Is it possible to do this?
You could change it by passing a parameter to a stored procedure or function. Problem is that the axis labels won't change.
Can't you just use a dual axis chart?