Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Charting from main Spreadsheet.
Here is my problem:
I have a Main Spreadsheet with the following columns: CUSTOMER NAME PRICE QTY Dave 1 2 Tom 5 1 Tom 6 1 Zack 4 2 Zack 2 1 Zack 9 1 I would like to run a Macro from this Main sheet that should create Charts based on the above 3 columns for each of the Customer Names there (Notice that a Customer Name can occur one or more times). I would like to have each of the Chart in one individual spreadsheet. The name of the spreadsheet should be the "Customer Name". Can someone let me know how I can get this done? A sample code perhaps? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
12 Sheets - Submit to One Main Spreadsheet | Excel Discussion (Misc queries) | |||
One-click Automatic Charting | Charts and Charting in Excel | |||
Information Flow to a main spreadsheet | Excel Discussion (Misc queries) |