Dynamic Charts...

herbycanopy · #1 04-01-2010, 01:27 PM

I was looking for a way that I can have a chart update when new information in entered every month. The problem is that I have two sets of numbers for each month. I would like to make a two charts one for A and one for B information and not have to remake the chart every month.

Code:

   January          February
  A        B          A        B
3423    659       185     1763

Any ideas would be great.
Aloha

EDIT: If you know that it can not be done please take 5 seconds to at least say "Cann't" so that I can stop spending all my time googling and trying to do something that can not be done.

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

It's very possible. See this article:

Dynamic Charts

Cheers,

herbycanopy · #3 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 · #4 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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