Evening the data
 

Have potted some line charts from data tables relating to vehicle flow
volumes. The maximum allowable flow is 24000, however, actual volumes exceed
this. I can limit the chart to only show up to 2400 but does anyone know a
way to automatically re-distibute the 'excess' flow and include it below the
maximum volume and to the right of that point??
Does that make sense????
Thanks

Evening the data
 

I don't quite see what you're after.

Perhaps a small numerical example would help here.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Philip Drury" wrote:

Have potted some line charts from data tables relating to vehicle flow
volumes. The maximum allowable flow is 24000, however, actual volumes exceed
this. I can limit the chart to only show up to 2400 but does anyone know a
way to automatically re-distibute the 'excess' flow and include it below the
maximum volume and to the right of that point??
Does that make sense????
Thanks