adjust data axis of the chart

[Taha]

I have customised my spreadsheets to draw charts automatically accordin
to data in the first worksheet
but I have to add and remove the 31st day in the graph manuall
according to the days of the month
is there anything I can do for resetting my chart automaticall
according to the date
y-axis = number of people
x-axis = days of the mont

 

[Gromit]

Hi,

The approach I'd first consider would be to create dymamic range name
on each sheet, then have your chart refer to the name ranges.

This summary by John Walkenbach is for a slightly different applicatio
but you should be able to adapt it to your needs.

Cheers,

Graham

http://j-walk.com/ss/excel/usertips/tip053.ht

 

[Tushar Mehta]

Check the Excel | Tutorials | 'Dynamic Charts' page of my web site.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office