How to filter data more than some value in Excel 2007?

Hi,
I have a set of data and and I use pivot table to create graphs. However, the x axis has so many values that each bar does not match with the right axis values. So I want to filter out the data that are less then 20 and just show the rest on the graph.

How can I do that in Excel 2007?

Thanks,
TolgarAsked:
Who is Participating?
 
SiddharthRoutCommented:
Ok, Here is an example. Do this

Create chart for all your data. Include X and VALUES
Now, apply data filters to the source data range (menu > data > filter > auto filter, in excel 2007, use home ribbon > filter & sort button > filter)
Select the type of data you want to use in the chart by applying a data filter

And you are done.

For example if you select >20 in the filter then the chart will populate accordingly :)

Sample Attached.

Sid
Chart.xlsx
0
 
SiddharthRoutCommented:
Tolgar, May I see your file?

Sid
0
 
TolgarAuthor Commented:
Let's say this is the data. Then I draw a bar graph. But I only want to see the A, B and E in the x axis because their values are bigger than 20.

X Values in A column:
A
B
C
D
E

Y values in B column:
153
36
14
4
31


I hope this helps.

Thanks,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.