Dynamic Charts...

ConneXionLost · #1 04-01-2010, 09:32 PM

It's very possible. See this article:

Dynamic Charts

Cheers,

herbycanopy · #2 04-01-2010, 10:49 PM

shoot the term is even Dynamic Charts...I been googling everything but that... thanks for the help.

Aloha

EDIT: Ok so that is easy but in the example they tell you only how to do dynamic charts that use columns and do not need to skip data. How do I tell it to use data that is in rows? How do I tell it to skip every other column?

herbycanopy · #3 04-09-2010, 05:58 PM

Quote:

Originally Posted by herbycanopy

Ok so that is easy but in the example they tell you only how to do dynamic charts that use columns and do not need to skip data. How do I tell it to use data that is in rows? How do I tell it to skip every other column?

Sorry I must be really bad at explaining what I need done. I will try again, again.

Using Dynamic Charts you can use information in Columns like this...

HTML Code:

How can I use information that is in Rows like this....

HTML Code:

   1      2      3      4

The next part is harder. I now need only have it find the totals in Column A of Row 1 but ignore Column B of Row 1. Like this...

HTML Code:

   A      B      A      B      A      B   
   1      2      3      4      5      6

So now it would Graph the numbers 1, 3, and 5 only.

I hope that I did a better job explaining myself this time.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Newbie - Need help with inserting charts into slide using VBA	fretwizard	PowerPoint	1	06-23-2009 08:45 AM
copy/paste charts from excel to word	bielak01	Excel	0	04-16-2009 02:27 AM
Plotting LARGE WALL CHARTS	Butch Jackman	Excel	0	05-25-2006 07:06 AM
Using Charts	miller0822	Excel	0	02-10-2006 08:02 PM
Identifying the Dynamic Connector	cyberbhai	Misc	0	12-14-2005 03:55 AM