Interactive chart

Hi,

I made an inactive chart. My question is how I can change X axis intervals, while it interpreters my data based on new intervals?

As an example, I have 820, 920, 1475, eyc. I want to have 800, 850, 900, 950, etc. I know I can change it by formatting the axis. but if I change the intervals there, it just change the appearance and not the distribution of my data.

Can anyone advice?

I like FunChart7 from Stephen Bullen's site - it's under Charting Examples (scroll down) on this link:

http://www.oaltd.co.uk/Excel/Default.htm

and allows you to zoom in (and out) of a lot of data.

Hope this helps.

Pete