LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 54
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically adjust charts Ravens Fan Charts and Charting in Excel 6 December 3rd 07 06:40 PM
Is there a macro to create charts automatically? JDB Charts and Charting in Excel 5 July 23rd 07 09:52 AM
How to Automatically Create Scatter Plot Charts Chris Gregory Charts and Charting in Excel 8 October 13th 06 03:35 AM
How do I create charts that change source data automatically? cbalster Charts and Charting in Excel 0 May 26th 06 08:19 PM
Create charts that update automatically from data in rows Brent Charts and Charting in Excel 4 January 19th 06 12:50 PM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"