EXCEL Graph

  • Thread starter Thread starter Alex Simic
  • Start date Start date
A

Alex Simic

Dear all,

I have an issue with graph diagrams. Here a sample to illustrate the
situation:

1st row contains date: e.g. April 4 2006, April 7, 2006, April 5 2006
2nd row contains data e.g. 5 Dollar, 4 Dollar, -3 Dollar,

Now I want to create a graph which cumulates the 2nd row. Means:

X-axe:
April 4 2006
April 7, 2006
April 5 2006

Y-axe:
5 Dollar
9 Dollar
6 Dollar

How can I do this directly with the graph diagrams?
Thanks, Alex
 
I doubt that you can, but you can add a third row which is an
accumulation, and run the chart from Row 1 and Row 3. To hide the
accumulation set it's row height to 1.

For the accumulation, in B3 use =IF(B1<>"",B2+A3,"") and formula-drag
as far right as required.

HTH

--
 
Back
Top