Automatically create charts

  • Thread starter Thread starter enna49
  • Start date Start date
E

enna49

Here goes

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
0000 000 000 11001 Nov 07 90.00
0000 000 000 11001 Dec 07 92.00
0000 000 000 11002 Oct 07 101.00
0000 000 000 11002 Dec 07 101.00
0000 000 000 11003 Oct 07 101.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.
Any help on this matter would be appreciated.
Thanks
Anne
 
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
Click to expand...
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.
Click to expand...

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