Forum Discussion
Sagarkansal
Advocate I
Advocate IFiltering X and Y Axis in Scatter/Bubble Chart
I want to filter the X and y axis of Scatter plot chart on the basis of the particular column value/s in the respactive columns. The thing I wish to achieve is as follows: i.e I wish to show...
SagarkansalAdvocate I
Advocate IAnonymous.....
Here is the simplest Example
When I Put Year Column both in X and Y axis fields of the scatter plot, this is achieved:
Now I wish to filter the Years 2016 and 2017 on X anhd Y Axis of Sctter plot. I dod not want to Pivot Years onto Sales or creating another Table. The product I wish to achieve looks like this:
How can this be achieved?
Hi Sagarkansal,
I think you need to add other column to one of axises, you can't use same value to display different result on y axis and x axis.Regards,
Xiaoxin Sheng