[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

Walk Charts

Asked by andrewsudron in Microsoft Excel Spreadsheet Software, VB Objects, Spreadsheet Software

I need to create walk graph based on certain tabular data. Any ideas any help would be appreciated. The graph is to show what was the reasons for certain dollar amounts to go up or down within a certain timeframe. ie what categories of dollars. The effect is to see plus and minus deltas in between the from and to values. The from and to values and deltas would be shown as a bar chart format. I already have a working version created however needs to be completed. 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:

sample code :
Do While Range(WrkCursor).Value <> ""
   If IsNumeric(Range(WrkCursor).Offset(0, 1).Value) Then
      PrjCntr(0) = Range(WrkCursor).Offset(0, 1).Value / 1000000
      PrjFY(0) = Range("E70").Value
   End If
   If IsNumeric(Range(WrkCursor).Offset(0, 2).Value) Then
      PrjCntr(1) = Range(WrkCursor).Offset(0, 2).Value / 1000000
      PrjFY(1) = Range("F70").Value
   End If
  Desc1 = Range(WrkCursor).Value
 WrkRowBottom = Range(WrkCursor).Row
   WrkCursor = Range(WrkCursor).Offset(1, 0).Address
[+][-]10/26/09 04:31 AM, ID: 25661174Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/26/09 11:05 AM, ID: 25664955Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/22/09 02:12 PM, ID: 25883942Administrative Comment

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 30-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-92 - Hierarchy / EE_QW_3_20080625