Folks

Not sure if this is a specific VBA Question or just general Excel?

I want to create a chart with values for X starting at 22 as in:

Age 22 = 5 people
Age 23 = 7 people... etc

But when I create a chat, it always starts from x=1 y=5

How can I create a chart where the x values start from a number other than one?

Regards

Russ (Programing on L plates..!)

__________________
Regards

Russ (Programing on L plates..!)

I've just checked it out and it works fine.

Make sure you have one series with numerical values (e.g. 5 & 7) and then link the x-axis labels (e.g. 22 & 23). Make sure your not inputting 22 & 23 in the series name as this might give the effect your describing.

Ben