A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"automagically" generate charts?



 
 
Thread Tools Display Modes
  #1  
Old August 11th, 2004, 08:06 PM
R
external usenet poster
 
Posts: n/a
Default "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
  #2  
Old August 11th, 2004, 09:49 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default "automagically" generate charts?

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

  #3  
Old August 11th, 2004, 11:11 PM
R
external usenet poster
 
Posts: n/a
Default "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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 03:16 AM
printing multiple charts per page Pablo Charts and Charting 1 February 27th, 2004 06:37 PM
Creating a large number of charts automatically (repost) Francine Kubaka Charts and Charting 0 September 21st, 2003 09:16 PM


All times are GMT +1. The time now is 11:19 AM.


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