If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"automagically" generate charts?
Does Excel provide a way to generate
charts "automatically" (formula, macro, pivot, etc), based on row selection in a given range? And if so, how? I have a spreadsheet with hundreds of product names in column A, then, each month includes 4 columns of common sales person names. I would like to be able to generate a simple trend chart by selecting the product name in column A. Here's a simple example of my spreadsheet: A B C D E F G H I January February Product Jim Jon Tim Tom Jim Jon Tim Tom forks knives spoons plates Thanks, R |
#3
|
|||
|
|||
"automagically" generate charts?
Thanks for helping!
-----Original Message----- You should be able to adapt the ideas illustrated at http://www.tushar- mehta.com/excel/newsgroups/dynamic_charts/index.html specifically examples 4,5,6. WHile the data in those examples are column-based, the formulas are easily converted to row-oriented data. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Does Excel provide a way to generate charts "automatically" (formula, macro, pivot, etc), based on row selection in a given range? And if so, how? I have a spreadsheet with hundreds of product names in column A, then, each month includes 4 columns of common sales person names. I would like to be able to generate a simple trend chart by selecting the product name in column A. Here's a simple example of my spreadsheet: A B C D E F G H I January February Product Jim Jon Tim Tom Jim Jon Tim Tom forks knives spoons plates Thanks, R . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Make Pie Charts the Same Size | Jon Peltier | Charts and Charting | 0 | May 3rd, 2004 09:34 PM |
Distribute dynamically charts with linked data as stand-alone charts | Richard | Charts and Charting | 2 | March 31st, 2004 05:16 PM |
charts inadvertly resized | Hammer_757 | Charts and Charting | 0 | March 24th, 2004 02:16 AM |
printing multiple charts per page | Pablo | Charts and Charting | 1 | February 27th, 2004 05:37 PM |
Creating a large number of charts automatically (repost) | Francine Kubaka | Charts and Charting | 0 | September 21st, 2003 09:16 PM |