chart based on incremental difference

[robhargreaves]

Hi is it possible to chart based on a column of values and chart th
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 ther
has been a 500 increase in each value.

Thanks for your time.

Ro

 

[Tushar Mehta]

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

--
Regards,

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

nospam.com>, (e-mail address removed)
says...

 

[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/
_______