Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automatically create charts
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automatically create charts
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automatically create charts
hi
"enna49" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically adjust charts | Charts and Charting in Excel | |||
Is there a macro to create charts automatically? | Charts and Charting in Excel | |||
How to Automatically Create Scatter Plot Charts | Charts and Charting in Excel | |||
How do I create charts that change source data automatically? | Charts and Charting in Excel | |||
Create charts that update automatically from data in rows | Charts and Charting in Excel |