1

I have a list with 3 columns, Month, volvo, benz. I have created a chart which contains 2 series, volvo and benz. It shows 2 series based on month, for example for jan, it shows value volvo & benz bar, for feb, it shows different value of volvo & benz. Now i want to filter the chart by column i.e if i type volvo, all volvo bar should be filtered and if i type benz, all benz bar should be filtered.

How to do it? I tried with text filter but in that you have to give a value from the column whereas i want all values of a particular column.

Improve this question

2 Answers 2

Reset to default
2

See if this helps:

Have the chart get its data through a connection to the list web part.

Briefly:

  1. Add both chart and list webpart to a page
  2. Edit the chart webpart and have it pull connection from the list web part
  3. Filter the list webpart columns accordingly (volve or benz)
  4. This should update the chart to the filter of the list
Improve this answer
0

Using the free Google Chart Web Part from Amrein Engineering, I was able to complete something similar to your request.

Google Chart Web Part

Improve this answer
1
  • I cant use third party tools. Is there anyway by in-build sharepoint chart web part?
    – harsh
    Jun 6, 2012 at 5:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.