View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
bg3119 bg3119 is offline
external usenet poster
 
Posts: 2
Default Chart formate changing when saved

I have over ten different charts that I copy into a report out workbook at
then end of each month. The normal stuff Date, goal, actual. the data
format is set for % so the the 0.15 will show up on the chart as 15% when I
save it. When my boss opens the chart it show up as 0.15 again.

How do I make it keep the format I created it in??

The Date does the same thing but only on some of the charts. Starts as a
date (month-yr) then it changes to 12345 general number.