Line graph and filters visualization plot issue

[amitnewbee123]

Hi experts,
I have a set of test data as shown in Test.xlsx .I want to display it in a visualization say line chart as shown in expected visual.jpg in the attached screenshot.
I need to include 3 filters l6, l2,l4 so that when we select these values then the corresponding line graph is formed with k and F values plotted in y and x axis respectively.

I also need to show each of the data point values in the line graph of k and f when I select the filter values in l6,l4,l2. By seeing the line graph, i know which point of K and F values corresponds to which values of l6,l2,l4 .

regards
Amit

 

[vletm]

amitnewbee123​

Did You test this with Your previous thread's solution?

 

[amitnewbee123]

amitnewbee123​

Did You test this with Your previous thread's solution?

i did try but in this case we have 3 filters and we need to also show the selected data in the filter in the line graph.The previous solution didnt fit this requirement.It had only 1 filter.

Any thoughts?

 

[vletm]

Explain other words with Your sample file
- what do You expect to get ? ... with better visual sample too.

 

[amitnewbee123]

Explain other words with Your sample file
- what do You expect to get ? ... with better visual sample too.

I want to create a line graph between K and F and create three filters l6,l4,l2 and when the values are selected in each of these filters then it should also show in the line graphs so that i know the corresponding filter values result in this particular data point intersection of k and F , I mean i want to show all the values l6,l4,l2,k and F in a single line chart.

If we go by recommended visuals it will create too many charts and create legends corresponding to it.

It is just my proposal, if you think there is a better way to represent all these data in a single chart, please suggest.

expected visual.jpg and Test.xlsx are the expected graphs and input data sample

 

[p45cal]

I'm not at all clear; like this?:

 

[amitnewbee123]

I'm not at all clear; like this?:

View attachment 87604

yes exactly, could you please share the excel sheet.I can check at my end for the values?

 

[p45cal]

The file:

 

[p45cal]

When people don't say thank you, they can expect loads of help from me in the future.

 

[amitnewbee123]

When people don't say thank you, they can expect loads of help from me in the future.

Thankyou sir...i actually was out for a while...please dont be angry