Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
make macros in charts
can someone tell me how to make a macro that will work in a chart,
specifically how to format a chart to format the chart and plot areas, and properties (do not move/size with chart). I tried to create the macro, but I get errors. thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
make macros in charts
Hi,
It would help if you explained what the errors where and also shown your code. This code will set Don't Move and size property of chartobject as well as set plotarea to automatic border and fill. '-------------------------- Sub Macro1() ' With ActiveSheet.ChartObjects(1) ' don't move and size chart object .Placement = xlFreeFloating With .Chart With .PlotArea .Border.LineStyle = xlAutomatic .Interior.ColorIndex = xlAutomatic End With End With End With End Sub '---------------------- Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "jana" wrote in message ... can someone tell me how to make a macro that will work in a chart, specifically how to format a chart to format the chart and plot areas, and properties (do not move/size with chart). I tried to create the macro, but I get errors. thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make macros run smoothly? (without the flickering) | Excel Discussion (Misc queries) | |||
make macros usable! make instructions in plain english !!!! | Excel Worksheet Functions | |||
How do I update charts using macros | Charts and Charting in Excel | |||
Excel Charts(Graphs) & Macros | Excel Discussion (Misc queries) | |||
Macros & pie charts | Charts and Charting in Excel |