Is This Possible??

[q582gmzhi]

Hi,

I am sure this can be done but I am not sure how to achieve it!

I currently create a graph by manually entering data in excel, I the
sort the data by value order (highest to lowest), the graph then refer
to the worksheet data and displays the graphs in numerical orde
(highest to lowest).

I have now been asked to use the same data but create 4 other graphs
representing a separate region.

The easiset way is to create 4 other data entry sheets one for eac
region, enter the data and refer the separate graphs to the relevan
region.

However I will be duplicating the workload by having to enter the sam
data twice.

How can I use the same data on one worksheet, but then filter it fo
each region and create the 4 graphs in numerical order?

Thanks in advance

Daz..