Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help on "Aligning text boxes in a chart sheet"
I use VBA to create XY-scatter graph on a seperate chart sheet and plot data
points. I also create a set of text boxes on both left and right side of the graph. But, on the right side of the graph, the "left" position of the text boxes are not uniform ( even though I pass same constant value as left point og each text box ). The text boxes are misaligned automatically. Can any of you give me a solution for this ??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help on "Aligning text boxes in a chart sheet"
Just a guess, but perhaps you should set the left position of the textboxes
as the last thing in your macro, after the chart is completely built. You also might play with the "size with chart" settings of the textboxes and see if this has an effect (protection tab). Activechart.Textboxes(1).Placement = xlMoveAndSize ' means size with chart ActiveChart.Textboxes(1).Placement = xlMove ' means don't size with chart -- Regards, Tom Ogilvy "Senthil R" <Senthil wrote in message ... I use VBA to create XY-scatter graph on a seperate chart sheet and plot data points. I also create a set of text boxes on both left and right side of the graph. But, on the right side of the graph, the "left" position of the text boxes are not uniform ( even though I pass same constant value as left point og each text box ). The text boxes are misaligned automatically. Can any of you give me a solution for this ??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to eliminate E-mail "To" & "CC" boxes at top of Excel Sheet | Excel Discussion (Misc queries) | |||
"aligning option buttons" | Excel Worksheet Functions | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
How do I split "A1B2" into "A1" and "B2" using text to column fun. | Excel Programming |