chart based on incremental difference

[robhargreaves]

Hi is it possible to chart based on a column of values and chart the difference of the increment?

example of data

a1- 1000
a2- 1500
a3- 2000
a4- 2500
a5- 3000

and in this example there would be a flat line at 500 units as there has been a 500 increase in each value.

Thanks for your time.

Rob

[Tushar Mehta]

In a separate column calculate the increments. Then, use the technique
illustrated at
Step chart
http://www.tushar-mehta.com/excel/ch...art/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <robhargreaves.1smlia_1122127502.7703@excelforum-
nospam.com>, robhargreaves.1smlia_1122127502.7703...rum-nospam.com
says...
>
> Hi is it possible to chart based on a column of values and chart the
> difference of the increment?
>
> example of data
>
> a1- 1000
> a2- 1500
> a3- 2000
> a4- 2500
> a5- 3000
>
> and in this example there would be a flat line at 500 units as there
> has been a 500 increase in each value.
>
> Thanks for your time.
>
> Rob
>
>
> --
> robhargreaves
> ------------------------------------------------------------------------
> robhargreaves's Profile: http://www.excelforum.com/member.php...o&userid=25519
> View this thread: http://www.excelforum.com/showthread...hreadid=389585
>
>

[robhargreaves]

Hi Thanks a lot for your reply

The method you propose does work well. But I need to do it without adding columns to take the difference. Is it possible to do it this way?

Thanks again

Rob

[Jon Peltier]

Rob -

You have to somehow provide the data for the chart. Why can't you add a column?
Could you put it in a different part of the sheet (or a different sheet) so it
doesn't mess up your nicely formatted worksheet?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

robhargreaves wrote:

> Hi Thanks a lot for your reply
>
> The method you propose does work well. But I need to do it without
> adding columns to take the difference. Is it possible to do it this
> way?
>
> Thanks again
>
> Rob
>
>