Data labels switch to text boxes on negative values

[Cooter]

Hello-

I am not sure if this has been asked previously but I am having an
issue with a number of charts that I populate using a macro. The
charts are all horizontal bar charts and in the macro I auto format
the data labels. When I save the file in the macro the labels of the
negative values switch from being a data label to a floating text
box. Has anyone experienced this? Is there something that can be
done to fix this?

Thanks,

 

[Jon Peltier]

What version of Excel is this? Could you post the relevant code?

- Jon

 

[Cooter]

What version of Excel is this? Could you post the relevant code?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______








- Show quoted text -

I am using Excel 2003. I can post the code but it is over 1000 lines
long and I don't think it is due to the code. It is a simple macro
that just updates data based on a monthly data file. I have gotten
this error in other workbooks that I have built that use vlookup/
indirect/offset to bring in the data. The chart is fine until I save
it and then the negative data labels get corrupted. I can send the
code directly to you if you think it would help to look into the
issue.

Thanks

 

[Jon Peltier]

You can send the file. I can't promise to give it much attention, but I am a
bit curious. Put this discussion into the email.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

What version of Excel is this? Could you post the relevant code?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______








- Show quoted text -

I am using Excel 2003. I can post the code but it is over 1000 lines
long and I don't think it is due to the code. It is a simple macro
that just updates data based on a monthly data file. I have gotten
this error in other workbooks that I have built that use vlookup/
indirect/offset to bring in the data. The chart is fine until I save
it and then the negative data labels get corrupted. I can send the
code directly to you if you think it would help to look into the
issue.

Thanks