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
_______
"Cooter" <(E-Mail Removed)> wrote in message
news:2f0afb8b-23fc-46ea-92d8-(E-Mail Removed)...
On Apr 28, 5:54 pm, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com>
wrote:
> 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
> _______
>
> "Cooter" <coryp...@gmail.com> wrote in message
>
> news:a38c9e10-eee5-4981-8cab-(E-Mail Removed)...
>
>
>
> > 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,- Hide quoted text -
>
> - 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
Similar Threads
