Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default controlling chart location

I have a process for making some charts, which I then place into
another sheet using 'activechart.location 2, sheetname'. Is there a
way to control where on the new sheet this ends up? If I send several
charts this way, they end up in the same location, so that I have to
drag them over to see them all. Here is the charting portion of my
code:

ActiveSheet.Shapes.AddChart(xlLine, 250, 15, 400,
200).Select
With ActiveChart
.SetSourceData Source:=primeTLAhistorng
.SeriesCollection(1).Name = Cells(2, 26)
.SeriesCollection(1).XValues = range(Cells(3, 25),
Cells(tlachtendrw, 25))
.SeriesCollection.NewSeries
.SeriesCollection(2).Values = TLAhistorng
.SeriesCollection(2).Name = TLAhistoname

.Legend.Position = xlBottom

.HasTitle = True
.ChartTitle.Text = "chart title goes here"
.ChartTitle.Font.Size = 12

.Axes(xlCategory).HasTitle = True
.Axes(xlCategory).AxisTitle.Text = "axis title
goes here"
.Axes(xlCategory).AxisTitle.Font.Size = 10
.Axes(xlCategory).TickLabels.Orientation = 90
.Axes(xlCategory).TickLabels.Font.Size = 8
.Axes(xlCategory).HasMajorGridlines = True

.Axes(xlValue).HasTitle = True
.Axes(xlValue).AxisTitle.Text = "value axis title
goes here"
.Axes(xlValue).AxisTitle.Font.Size = 10
.Axes(xlValue).TickLabels.NumberFormat = "0%"
.Location 2, "Chart_Display"
End With
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default controlling chart location

Never mind, i figured it out. the location you give it with 'addchart'
is the location it will have in the new sheet.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stacked Line Chart - Excel 2007 - Controlling the separation Harry Charts and Charting in Excel 2 January 20th 10 07:45 PM
Controlling Gap Width for BAR Chart Fazi Charts and Charting in Excel 4 February 24th 07 03:39 PM
Controlling Chart Views Andy the yeti Excel Programming 3 January 20th 06 02:22 PM
Controlling excel chart axis Rain Charts and Charting in Excel 1 January 20th 05 01:15 AM
Controlling chart axis Rain Excel Programming 0 January 16th 05 07:49 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"