The chart will use the same format as the cells it is referencing. so
if you change the format of the cells where the dats are located the x
axis on the chart ill also change. Now if you need to have the cells in
one format and the chart in another format then you have to create a new
table on the worksheet and have the chart refere to the new table. You
caqn have the old table and new table linked by making the new table a
formula.
If your old table is A1:D10 then make a new table at G1:J10 and put the
formula =A1 at G1. Then copy the formula to G1:J10 and have then format
the two tables so one shows the entire date and the 2nd just the year.
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=182104
Microsoft Office Help