Data labels switch to text boxes on negative values
 

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,

Data labels switch to text boxes on negative values
 

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" wrote in message
...
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,

Data labels switch to text boxes on negative values
 

On Apr 28, 5:54*pm, "Jon Peltier"
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" wrote in message

...



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

Data labels switch to text boxes on negative values
 

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" wrote in message
...
On Apr 28, 5:54 pm, "Jon Peltier"
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" wrote in message

...



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