View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ibeetb ibeetb is offline
external usenet poster
 
Posts: 67
Default AUTOMATING CHARTS W/VBA

I have a regular area chart and my data labels are several points away from
where the value crosses the X axix.....in other words I need my data labels
to move up each time the graph is drawn. I am using VBA to draw the graphs
automatically - I know I can move the labels manually but since I have this
fully automated, I need to automatically have the data labels sit on top of
the value where the top of my area graph crosses the X axis......

can anybody help?