ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   AUTOMATING CHARTS W/VBA (https://www.excelbanter.com/excel-programming/282893-automating-charts-w-vba.html)

ibeetb

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?



JT143

AUTOMATING CHARTS W/VBA
 
Did you receive an answer to this yet

----- ibeetb wrote: ----

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

can anybody help





All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com