How do I make fixed format of chart everytime when publish it?

Hi All,

I got a problem when publishing a chart. The chart format always change
everytime I did publishing to the web. The legeng always move and the chart
title as well. The size of the plots also changed everytime I published it as
web files.

How to fix it? and How to lock the chart format??

Thanks

I have some kind of similar problem,
Every thing is ok, the only problem is what i get in my webpage is different from what i have in my worksheet.
I have table and a chart which should be align to each other.
In work sheet every thing is fine, but in webpage the chart will be stretched about 2 more line.
in some cells i have almost no control in the text alignments and font sizes.

I have couple of other files completely the same but different source of data.
the are all fine.

---------- Post added at 02:42 PM ---------- Previous post was at 02:41 PM ----------

Originally Posted by Rahmat

Hi All,

I got a problem when publishing a chart. The chart format always change
everytime I did publishing to the web. The legeng always move and the chart
title as well. The size of the plots also changed everytime I published it as
web files.

How to fix it? and How to lock the chart format??

Thanks

First you should check the auto publush each time you save your file.
then write macro like,

Please Login or Register  to view this content.