View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson Greg Wilson is offline
external usenet poster
 
Posts: 747
Default viewing big charts

Why not just embed the chart in a worksheet instead of creating a chart sheet
and size it manually to suit? If you don't want someone to be able to scroll
beyond the limits of the chart then add the following code to the
ThisWorkbook code module:

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A1:T50"
End Sub

Change the referenced range (here "A1:T50") to fit the range occupied by the
chart. You will likely have to adjust the row height, column widths and chart
dimensions slightly so that the user can't see any leftover worksheet when
scrolling to the limits of the range.

Regards,
Greg

"inquirer" wrote:

Is there any way to create large charts in excel, ie those that exceed the
screen size, and view them by creating scroll bars and scrolling right/left,
up/down ?
Chris