Thread: [Solved] Dynamic Charts...
View Single Post
 
Old 04-09-2010, 05:58 PM
herbycanopy herbycanopy is offline Windows XP Office 2007
Novice
 
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