Forum Discussion
Clustered Bar Values
Hello Everyone! I want to display some values in Clustered Bar Chart. My table has three columns and data is available in following format. |Column 1| Column 2| Column 3| |exp 1 | 23.2...
Michiel Dear, i want to achieve this. Is it possible? i want to change values on x and y axis using slicer. These values are available in one column on different rows.
Still not getting it. This is still a bar chart as in your first question? In the Y-axis slicer, you could select e.g. 'exp 1' and 'exp 2' as I mentioned earlier. Don't see how you would select a col1 value in the second slicer for the X-axis, though. I assume the value in the chart will be the sum of the values in col 2?
Yes VALUE will be sum or average of the values in the col 2.
As far as the chart is concerned, Yes i am refering to a bar chart. Is there any possible way to select dynammic x-axis and y-axis through slicers?