On Wed, 20 Feb 2008, in microsoft.public.excel.charting,
enna49 said:
I have about 4000 lines of data and wish to create charts depending on
certain criterea eg

MobileNo Loc Month Amount
0000 000 000 11001 Oct 07 89.00

The main criteria would be LOC and wish to produce the chart for 3 month for
each separate Mobile No within a Loc with the months shown separately in a
Column Chart.

Make a Pivot table with the 4000 lines data, and make a chart from that.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.