Forum Discussion
Filter rows in a chart
I have an Excel spreadsheet with ACTUAL and PLAN values for different months. I have thought of displaying, for example, the ACTUAL number of machines in a bar chart and the PLAN values in the same chart with a line chart.
When I am adding the ACTUAL numbers, I can filter by the months.
But how can I now set the line chart to show only the plan values?
Because atm it shows everything and I cant filter by.
Thank you for your help
tuncay ,
Sure. Below are the screenshots of your data and tables can be to achieve this
Index colmn is used here as the Key Column
Relationship and cross filter direction can be modified based on your need.
Actual data table:
Plan data table:
Tables joined using key column:
Chart:
This is just a representation. Set the data aggregations as your expectation to show the right values in the chart
Hope this helps!!!
Mark it as solution if this is what you are expecting!! Appreciate with a kudo if this solves!!
3 Replies
Hi tuncay ,
The Structure of your doubt won't support this requirement of showing some row values in bar chart and the rest in line chart.
You might have to split your dataset as Actual and Plan values separated. Have a key column and link them by the column.
This way actual can be shown in a bar chart while the plan values can be shown in line chart
tuncay ,
Sure. Below are the screenshots of your data and tables can be to achieve this
Index colmn is used here as the Key Column
Relationship and cross filter direction can be modified based on your need.
Actual data table:
Plan data table:
Tables joined using key column:
Chart:
This is just a representation. Set the data aggregations as your expectation to show the right values in the chart
Hope this helps!!!
Mark it as solution if this is what you are expecting!! Appreciate with a kudo if this solves!!
