Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What syntax do I need to position the active chart in a certain position on
a worksheet? I'm doing this from MS Access, here's a code snippet: With objXL.ActiveChart .HasTitle = True .ChartTitle.Characters.Text = "My Title" .Axes(xlCategory, xlPrimary).HasTitle = True .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "Week No" .Axes(xlValue, xlPrimary).HasTitle = False End with This all works nicely but I want to put the chart at certain coordinates on the sheet. Any clues? Many thanks. Keith. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to change position of chart labels on line chart | Charts and Charting in Excel | |||
Real Newbie newbie question | New Users to Excel | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Changing chart title changes position of chart | Excel Programming | |||
Newbie VBA: How to test second position in a cell? | Excel Programming |