View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrea Andrea is offline
external usenet poster
 
Posts: 112
Default Serial date to calendar format in charts

I have a chart that shows dates on the x-axis such as "Jan-09". When I copy
the chart into the presentation deck, the format changes to the excel serial
date if I close the original file. When the original file is open the dates
show as "Jan-09" like I want them. But when the original file is closed even
if I format the dates in the presentation nothing happens. Breaking the
links doesn't help. I know I've fixed this before but can't figure out how
to do it again. Can anyone help?
--
Andrea