[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

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,
0
Tolgar
Asked:
Tolgar
  • 2
1 Solution
 
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
 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now