Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-01-2010, 01:27 PM
herbycanopy herbycanopy is offline Dynamic Charts... Windows XP Dynamic Charts... Office 2007
Novice
Dynamic Charts...
 
Join Date: Mar 2010
Posts: 9
herbycanopy is on a distinguished road
Default Dynamic Charts...

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.

Last edited by herbycanopy; 04-01-2010 at 05:38 PM.
Reply With Quote
  #2  
Old 04-01-2010, 09:32 PM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Dynamic Charts... Windows XP Dynamic Charts... Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

It's very possible. See this article:

Dynamic Charts

Cheers,
Reply With Quote
  #3  
Old 04-01-2010, 10:49 PM
herbycanopy herbycanopy is offline Dynamic Charts... Windows XP Dynamic Charts... Office 2007
Novice
Dynamic Charts...
 
Join Date: Mar 2010
Posts: 9
herbycanopy is on a distinguished road
Default

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?

Last edited by herbycanopy; 04-02-2010 at 11:33 AM.
Reply With Quote
  #4  
Old 04-09-2010, 05:58 PM
herbycanopy herbycanopy is offline Dynamic Charts... Windows XP Dynamic Charts... Office 2007
Novice
Dynamic Charts...
 
Join Date: Mar 2010
Posts: 9
herbycanopy is on a distinguished road
Default

Quote:
Originally Posted by herbycanopy View Post
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:
   1
   2
   3
   4
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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Charts... 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft